Is there any other efficient way to retrieve all the folders and files of a Alfresco space using Alfresco web script as well as the total documents count

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.

rashi

I have tried to extract the folders and documents information using below CMIS query in web script.

SELECT * FROM cmis:document WHERE IN_TREE('"+child.nodeRef+"')

SELECT * FROM cmis:folder WHERE IN_TREE('"+child.nodeRef+"')

But cmis:document giving me incorrect result. For example if I have large number of empty child folders and there s document available after traversing 7-8 folders levels. In this scenario I am receiving 0 result if I use the cmis:document query.

Kindly suggest If any one having good and optimised solution for the same.

I am using 3.4 Version of Alfresco.

afaust

With Alfresco 3.4 (extremely old version) there is no efficient way to determine that just via search. I would advise to upgrade to a more recent version which uses SOLR. With that you can perform CMIS/FTS queries that do not need to load any data (which could be truncated by permission checks), but still give you a "numberFound" search result meta attribute for the number of results found in the index.