Report Documents in Folder with latest Version

Peter Stegl

I need an report for Dokuments in an folder with the latest modify date except perimission change. I find out that dauditnew.auditdate stores 11 for "New Version".

select name from dtree, dauditnew.dataid where subtype=144 CONNECT BY PRIOR dataid = parentid start with dataid= %1 where dauditnew.dataid = dtree.dataid and where dauditnew.auditid in (11)

unfortunately I get this: Livelink Error: Error processing request.

Livelink Error: Error processing request.

[ORA-00933: SQL command not properly ended - select name from dtree, dauditnew.dataid where subtype=144 CONNECT BY PRIOR dataid = parentid start with dataid= 3958215 where dauditnew.dataid = dtree.dataid and where dauditnew.auditid in (11)]

can anyone help?

Oracle with LL9.7.1

Thank you ! Peter

 

 

Colin_Schmidt

You can get the latest version from the DTREE.VERSIONNUM and the date.  You don’t need the DAUDITNEW table for that.  If the DTREE.Modifydate is something you don’t want to rely on, then it’s still “cheaper” to use the DVERSDATA:

select dt.name, dv.vercdate

from dtree dt

join dversdata dv on dt.dataid = dv.docid and dt.versionnum = dv.version

where dt.subtype=144 CONNECT BY PRIOR dt.dataid = dt.parentid start with dt.dataid= %1

 

 

Colin J. Schmidt

MSLive/Livelink Admin

Tulsa, OK 74172

 

Colin.Schmidt@williams.com

If you have received this message in error, please reply to advise the sender of the error and then immediately delete this message.

 

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Monday, March 25, 2013 9:10 AM
To: eLink Recipient
Subject: Report Documents in Folder with latest Version

 

Report Documents in Folder with latest Version

Posted by peter.stegl@axpo.ch (Stegl, Peter) On 03-25-2013 08:39

 

I need an report for Dokuments in an folder with the latest modify date except perimission change. I find out that dauditnew.auditdate stores 11 for "New Version". select name from dtree, dauditnew.dataid where subtype=144 CONNECT BY PRIOR dataid = parentid start with dataid= %1 where dauditnew.dataid = dtree.dataid and where dauditnew.auditid in (11) unfortunately I get this: Livelink Error: Error processing request. Livelink Error: Error processing request. [ORA-00933: SQL command not properly ended - select name from dtree, dauditnew.dataid where subtype=144 CONNECT BY PRIOR dataid = parentid start with dataid= 3958215 where dauditnew.dataid = dtree.dataid and where dauditnew.auditid in (11)] can anyone help? Oracle with LL9.7.1 Thank you ! Peter

---

[To post a comment, use the normal reply function]
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center