Hi
How to retrieve all documents in side a container?
This container is having compound documents with revisions. We need documents inside every revision of a compound document.
Can some body help me on this please?
Regards,
A Compound Doc seems to be much like a folder. Taking the DTREE.DATAID of a compound doc (Subtype = 136), and making it the DTREE.PARENTID, you find the contents listed out. The DTREE.CHILDCOUNT of the Compound Doc provides the count of how many are within.
To list all this would involve a simple query and a SubQuery.
Colin J. Schmidt
MSLive/Livelink Admin
One Williams Center
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: Sunday, March 03, 2013 11:16 PMTo: eLink RecipientSubject: List all documents in a container
List all documents in a container
Posted by livelinkadmin@pdo.co.om (Admin, Livelink) On 03-04-2013 00:13
[To post a comment, use the normal reply function]
Forum:
Content Server LiveReports Forum
Content Server:
Knowledge Center
how about this
select dataid, name, sys_connect_by_path(name,':') as "Path" , subtype from DTree connect by prior dataid=parentid start with dataid=%1
make sure %1=container
If its just a list of content, you may be better using DTREEANCESTORS table rather than the CONNECT BY PRIOR statement to get the same results.
