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.
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.
Ask for and offer help to other Alfresco Content Services Users and members of the Alfresco team.
Related links:
By using this site, you are agreeing to allow us to collect and use cookies as outlined in Alfresco’s Cookie Statement and Terms of Use (and you have a legitimate interest in Alfresco and our products, authorizing us to contact you in such methods). If you are not ok with these terms, please do not use this website.