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

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