Audit Date Problem in LiveReport

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

Martin_Gäckler

The Problem is, that DAUDIT does not store the information which version was reserved and unreserved.