04-11-2018 05:10 AM
Hi All,
Im using node browser and my query is SELECT cmisbjectId,cmis:name,cmisath FROM cmis:folder WHERE CONTAINS('PATH:"//app:company_home/st:sites/cmims-metro-carmen/cm:documentLibrary/cmENZ50//*"') where I will go to the specific folder where it contains pdf file while using that query it directly displays (please see photo below)
instead all I want is just to display directly the children of the specific folder in which you can see the photo below,
Is this possible? Thanks
04-12-2018 08:07 AM
The CMIS spec is quite clear about this - you need to the CMIS object ID of the folder to use IN_TREE. In Alfresco, the CMIS object ID is either the full reference or only the UUID part of it, depending on the CMIS API you are using (Public API vs. raw OpenCMIS endpoints). Ideally, you only use the public API and thus only need to use the UUID part.
04-11-2018 09:03 PM
help on this pls thanks
04-12-2018 04:25 AM
04-12-2018 04:51 AM
04-12-2018 04:27 AM
You should select for cmis:documents instead of cmis:folder to list the documents.
Also, there is a far better option than using CONTAINS + PATH to select by a common ancestor. CMIS has the IN_TREE operator to select anything below a specific base folder. You'd just need to resolve the base path against the folder ID and user that as a parameter to IN_TREE.
04-12-2018 04:50 AM
Thanks for the advice Axel Faust, so putting in the IN_TREE parameter, will I use reference? or parent? or what type?
04-12-2018 08:07 AM
The CMIS spec is quite clear about this - you need to the CMIS object ID of the folder to use IN_TREE. In Alfresco, the CMIS object ID is either the full reference or only the UUID part of it, depending on the CMIS API you are using (Public API vs. raw OpenCMIS endpoints). Ideally, you only use the public API and thus only need to use the UUID part.
04-12-2018 07:58 PM
Explore our Alfresco products with the links below. Use labels to filter content by product module.