Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Content Management (Extended ECM)
API, SDK, REST and Web Services
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