Find number of files in repository folder

[shankhamajumdar]

Hi,

I am using Alfresco Community 5.2.0. I have created multiple folders inside repository and in each folders I have uploaded lots of files. I would like to find out the count of number of files uploaded in each and every folder inside the repository. I want to check that from Postgres db using sql. Can you please provide me the query for that?

Regards,

Shankha

[angelborroy · Accepted solution]

You can find different methods to count nodes at https://angelborroy.wordpress.com/2018/05/30/alfresco-counting-more-than-1000-elements/