topic Re: get the number of files of each type in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/get-the-number-of-files-of-each-type/m-p/52976#M19854 <HTML><HEAD></HEAD><BODY><P>Are you using CMIS ?<BR />Please refer this documentation&nbsp;<A __default_attr="4673" __jive_macro_name="document" _jive_internal="true" class="jive_macro jive_macro_document link-titled" href="https://community.alfresco.com/docs/DOC-4673-search" rel="nofollow noopener noreferrer"></A>&nbsp; you can also use lucene query to search all document by type , within alfresco or within a path of your search folder .</P><P></P><P>Thanks,<BR />Kalpesh</P></BODY></HTML> Sat, 03 Feb 2018 07:42:53 GMT kalpesh_c2 2018-02-03T07:42:53Z get the number of files of each type https://connect.hyland.com/t5/alfresco-forum/get-the-number-of-files-of-each-type/m-p/52975#M19853 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: Wed, 24 Jan 2018 08:53:45 GMT https://connect.hyland.com/t5/alfresco-forum/get-the-number-of-files-of-each-type/m-p/52975#M19853 defrancile 2018-01-24T08:53:45Z Re: get the number of files of each type https://connect.hyland.com/t5/alfresco-forum/get-the-number-of-files-of-each-type/m-p/52976#M19854 <HTML><HEAD></HEAD><BODY><P>Are you using CMIS ?<BR />Please refer this documentation&nbsp;<A __default_attr="4673" __jive_macro_name="document" _jive_internal="true" class="jive_macro jive_macro_document link-titled" href="https://community.alfresco.com/docs/DOC-4673-search" rel="nofollow noopener noreferrer"></A>&nbsp; you can also use lucene query to search all document by type , within alfresco or within a path of your search folder .</P><P></P><P>Thanks,<BR />Kalpesh</P></BODY></HTML> Sat, 03 Feb 2018 07:42:53 GMT https://connect.hyland.com/t5/alfresco-forum/get-the-number-of-files-of-each-type/m-p/52976#M19854 kalpesh_c2 2018-02-03T07:42:53Z Re: get the number of files of each type https://connect.hyland.com/t5/alfresco-forum/get-the-number-of-files-of-each-type/m-p/52977#M19855 <HTML><HEAD></HEAD><BODY><P>Hi:</P><P></P><P>From database point of view you can&nbsp;check the following link:</P><P></P><P><A class="link-titled" href="https://blog.dbi-services.com/alfresco-some-useful-database-queries/" title="https://blog.dbi-services.com/alfresco-some-useful-database-queries/" rel="nofollow noopener noreferrer">https://blog.dbi-services.com/alfresco-some-useful-database-queries/</A>&nbsp;</P><P></P><P>Regards.</P><P>--C.</P></BODY></HTML> Sat, 03 Feb 2018 11:16:59 GMT https://connect.hyland.com/t5/alfresco-forum/get-the-number-of-files-of-each-type/m-p/52977#M19855 cesarista 2018-02-03T11:16:59Z Re: get the number of files of each type https://connect.hyland.com/t5/alfresco-forum/get-the-number-of-files-of-each-type/m-p/52978#M19856 <HTML><HEAD></HEAD><BODY><P>Hi:</P><P></P><P>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.</P><P></P><P><A class="link-titled" href="http://chemistry.apache.org/java/developing/tools/dev-tools-workbench.html" title="http://chemistry.apache.org/java/developing/tools/dev-tools-workbench.html" rel="nofollow noopener noreferrer">Apache Chemistry - CMIS Workbench</A>&nbsp;</P><P></P><P>Regards.</P><P>--C.&nbsp;</P></BODY></HTML> Sun, 04 Feb 2018 09:12:06 GMT https://connect.hyland.com/t5/alfresco-forum/get-the-number-of-files-of-each-type/m-p/52978#M19856 cesarista 2018-02-04T09:12:06Z