nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

All Doc. Version Reserved/UnReserved Date

John_Docherty_(jdocherty_(Delete)_1993785)

Regarding the Reserved/UnReserved Docs. Audit list, in the audit list of the documents, livelink shows only the reserve/unreserve date of the document (does not mention the versions), but i want to display the reserve/unreserve date of the all versions of that document in that Audit list.Can someone help me how can i write this livereport?Thanks

Find more posts tagged with

Comments

John_Docherty_(jdocherty_(Delete)_1993785)

SELECT DISTINCT DVERSDATA.DOCID, DVERSDATA.VERSION, DVERSDATA.VERCDATE, DAUDIT.AUDITDATE, DAUDIT.EVENT, DAUDIT.EVENTDESC FROM DVERSDATA DVERSDATA, DAUDIT DAUDIT WHERE DVERSDATA.DOCID = DAUDIT.DATAID AND (DAUDIT.EVENT = 'RESERVE' OR DAUDIT.EVENT = 'UNRESERVE')ORDER BY DVERSDATA.DOCID ASCPlease have a look at the above SQL Query and run this in Livelink LiveReport as a Auto Live Report. You can see the result of this query in the attached screen shot.The result shows the correct version creation date of the reserved/unreserved documents but it does not show the correct audit date in the LiveReport.Can anyone help me to solve this problem?Thanks & Regards