nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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.

Find more posts tagged with

Alfresco Content Services

Comments

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.