topic Re: Node Browser Query in Alfresco Forum

Node Browser Query

cyrose22 — Wed, 11 Apr 2018 09:10:51 GMT

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

Re: Node Browser Query

cyrose22 — Thu, 12 Apr 2018 01:03:28 GMT

help on this pls thanks

Re: Node Browser Query

cesarista — Thu, 12 Apr 2018 08:25:10 GMT

Hi:

Try with CMIS workbench:

Apache Chemistry - CMIS Workbench

Regards.

--C.

Re: Node Browser Query

afaust — Thu, 12 Apr 2018 08:27:49 GMT

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.

Re: Node Browser Query

cyrose22 — Thu, 12 Apr 2018 08:50:47 GMT

Thanks for the advice Axel Faust‌, so putting in the IN_TREE parameter, will I use reference? or parent? or what type?

Re: Node Browser Query

cyrose22 — Thu, 12 Apr 2018 08:51:23 GMT

‌ Thankyou sir for the advice (y)

Re: Node Browser Query

afaust — Thu, 12 Apr 2018 12:07:13 GMT

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.

Re: Node Browser Query

cyrose22 — Thu, 12 Apr 2018 23:58:36 GMT

Thanks for this sir ‌