cancel
Showing results for 
Search instead for 
Did you mean: 

Node Browser Query

cyrose22
Star Contributor
Star Contributor

Hi All,

Im using node browser and my query is SELECT cmisSmiley SurprisedbjectId,cmis:name,cmisSmiley Tongueath FROM cmis:folder WHERE CONTAINS('PATH:"//app:company_home/st:sites/cmSmiley Tongueims-metro-carmen/cm:documentLibrary/cmSmiley Very HappyENZ50//*"') 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

1 ACCEPTED ANSWER

afaust
Legendary Innovator
Legendary Innovator

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.

View answer in original post

7 REPLIES 7

cyrose22
Star Contributor
Star Contributor

help on this pls thanks

cesarista
World-Class Innovator
World-Class Innovator

Hi:

Try with CMIS workbench:

Apache Chemistry - CMIS Workbench 

Regards.

--C.

‌ Thankyou sir for the advice (y)

afaust
Legendary Innovator
Legendary Innovator

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.

cyrose22
Star Contributor
Star Contributor

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

afaust
Legendary Innovator
Legendary Innovator

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.

cyrose22
Star Contributor
Star Contributor

Thanks for this sir