Count of all documents including documents inside Sub folders in MS SQL

Manoj Agrawal

Hi,

Does anyone have an existing query for Common table Expression/Recursive query to find all documents inside a master folder including documents inside sub folder.

I am not an expert in writing those. I appreciate your help.

Thanks, Manoj

 

Colin_Schmidt

DO you want the count per Folder and in Sub-folder sequence?

Colin J

---

From: eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com>
Sent: Friday, April 13, 2018 11:17:40 AM
To: eLink Recipient
Subject: Count of all documents including documents inside Sub folders in MS SQL

 

Count of all documents including documents inside Sub folders in MS SQL

Posted by magrawal5@metlife.com (Agrawal, Manoj) On 04/13/2018 11:02 AM

Hi,Does anyone have an existing query for Common table Expression/Recursive query to find all documents inside a master folder including documents inside sub folder.I am not an expert in writing those. I appreciate your help.Thanks, Manoj

---

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

This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient(s), please reply to the sender and destroy all copies of the original message. Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email, and/or any action taken in reliance on the contents of this e-mail is strictly prohibited and may be unlawful. Where permitted by applicable law, this e-mail and other e-mail communications sent to and from Cognizant e-mail addresses may be monitored.