Queries for Alfresco Number of document by site (SQL)

[gabg02]

Hi !

I'm starting with alfresco and i'm seaching for some queries.

The first one was to get the number of document for each site. I already have queries to get the number of site and of documents but i don't manage to cross the requests.

My database is in Postgresql.

Thanks for your help.

[cesarista]

Hi:

Maybe an alfresco-fts query such SITE:siteshortname is easier for calculating the number of documents per site:

You can use Alfresco REST API or even SOLR query as used here: 

https://angelborroy.wordpress.com/2018/05/30/alfresco-counting-more-than-1000-elements/

In fact, you can type SITE:siteshortname in Alfresco Share search field and to check the number of results obtained.

Finally, if you have a healthy SOLR and Alfresco instance, you can try TYPE:"cm:content" in search field, and to see the number of results obtained in Site facet. 

Kind regards.

--C.