Queries for Alfresco Number of document by site (SQL)

gabg02 — Thu, 09 May 2019 15:03:40 GMT

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.

Re: Queries for Alfresco Number of document by site (SQL)

cesarista — Fri, 10 May 2019 07:01:41 GMT

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.

topic Queries for Alfresco Number of document by site (SQL) in Alfresco Forum

Queries for Alfresco Number of document by site (SQL)

Re: Queries for Alfresco Number of document by site (SQL)