How to search within a particular folder in the repository

[rita_aiyar]

Hi,

I have multiple folder within the repository. I want to search for documents within 1 particular folder using DotCMIS. How do i do that ?

Regards,
Rita

[kaynezhang]

Use IN_FOLDER() or IN_TREE() function in your cmis query.

SELECT cmis:name FROM cmis:document WHERE IN_FOLDER('folder id') //IN_FOLDER() matches the immediate children of a folder
SELECT cmis:name FROM cmis:folder F WHERE IN_TREE(F, 'folder id') //IN_TREE matches any object beneath the folder.
‍‍‍‍