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,
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.
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.