You are looking at documentation for an older release. Not what you want? See the current release documentation.
Query: Select all documents that are in folder1.
Initial data:
folder1: id - 123456789
document1: Title - node1
folder2:
document2: Title - node2
SELECT * FROM cmis:document WHERE IN_FOLDER('123456789')Query result:
document1.