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

Reserve/UnReserved LiveReport

John_Docherty_(jdocherty_(Delete)_1993785)

I am trying to create a Livelink report that gives me info. about Reserved/UnReserved Docs. But the result is repeating more that one time.Can someone help me to find the error in the following query?select %1, kuaf.Name "OName", DVersData.Version "Version", DVersData.MimeType, DVersData.VercDate "VercDate", DAUDIT.EVENT "Event" from Kuaf, DTree, DVersData, DAudit where (DAUDIT.EVENT = 'RESERVE') and %2 and (DTree.DataID = DVersData.DocID) and (DVersData.Owner = KUAF.ID) and (KUAF.ID = DAUDIT.USERID) and %3Param %1: ReportFieldsParam %2: Filter DocumentParam %3: Filter PermissionReport Format: LiveReportField: Column Title:VercDate Created OnOName Created ByVersion VersionEvent Event

Find more posts tagged with

Comments

Martin_Gäckler

Forget the join to daudit, because -your document is displayed more than once, if it has been reserved unreserved more than one time.- no document will be displayed if you have turned off auditing.- fetching the information directly from dtree is faster than joining to audit.Look at the fields:RESERVED RESERVEDBY RESERVEDDATEof your dtree table.Martin