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
Hi:
From database point of view you can check the following link:
https://blog.dbi-services.com/alfresco-some-useful-database-queries/
Regards.
--C.
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.
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.