You are viewing limited content. For full access, please sign in.

Question

Question

Document Count in a particular Folder in Repository

Updated February 2, 2018
asked on February 1, 2018

Team,

  I am using the below query to get the document count in the entire repository. How do I modify this query to get the count within a particular folder in the repository please?

 

select count(*) from toc where etype = -2

 

Thanks

Priya

0 0

Replies

replied on February 1, 2018

Hi Priya,

Do you need to go through SQL? You can get a count of all entries within a particular folder by running 'calculate size' on the folder in question through the Client.

0 0
replied on February 1, 2018

Thanks. Yes, we will need to go through SQL as we have an automated process that gives us the document count for all the repositories.

 

Priya

0 0
replied on February 1, 2018

You can use the 'parentid' column to filter for all documents contained within a specific folder. The parentid value will be the tocid of the parent folder. 

Note that this only will cover immediate children. You would need to construct the folder tree manually if you need to do multiple levels. 

0 0
replied on February 2, 2018

Thanks!

 

Priya

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...