Live Report to get all documents in one folder and its sub folders along with folder path where it is located
That should be documented somewhere in this Forum. That’s a frequent request. SQL and LRs have been posted in this forum about that specific request.
Colin J. Schmidt
Knowledgelink Support
CapitalOne | Collaboration Technology
From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Tuesday, August 09, 2016 10:31 AMTo: eLink Recipient <devnull@elinkkc.opentext.com>Subject: Live Report to get all documents in one folder and its sub folders along with folder path where it is located
Posted by Nalla, Mukhesh On 08/09/2016 10:29 AM
[To post a comment, use the normal reply function]
Forum:
Content Server LiveReports Forum
Content Server:
Knowledge Center
The information contained in this e-mail is confidential and/or proprietary to Capital One and/or its affiliates and may only be used solely in performance of work or services for Capital One. The information transmitted herewith is intended only for use by the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.
Thanks i got answer from Fourm..
Query is : SELECT DataID, Name, sys_connect_by_path(Name,':') as "Path"FROM DTreestart with DataID=%1 connect by prior DataID=ParentID
