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.

get the number of files of each type

defrancile

Hello, I need to get the number of files of each type. I have n models and in each one I have n types.
I have tried the solution that says here https://angelborroy.wordpress.com/2014/07/15/alfresco-%C2%B7-counting-elements-by-cmis-queries/ But I'm not going or I do not know what to putin this select:
SELECT cmis: objectId FROM cmis: document where IN_TREE ('[ID]') and cmis: objectTypeId = 'D: ks: docType';  I need help! Thank you

Find more posts tagged with

Alfresco Content Services

Comments

kalpesh_c2

Are you using CMIS ?
Please refer this documentation you can also use lucene query to search all document by type , within alfresco or within a path of your search folder .

Thanks,
Kalpesh

cesarista

Hi:

From database point of view you can check the following link:

https://blog.dbi-services.com/alfresco-some-useful-database-queries/

Regards.

--C.

cesarista

Hi:

And you can use CMIS workbench for getting these numbers for your document types with a groovy script. There is a demo example script for CMIS SQL queries included in CMIS workbench.

Apache Chemistry - CMIS Workbench

Regards.

--C.