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

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