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.