As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.
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.