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; } } }

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

Find more posts tagged with

Comments

Martin_Gäckler

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