JBoss.orgCommunity Documentation
Query: Select all documents that are in the tree of folder1.
Initial data:
folder1: id - 123456789
document1
folder2:
document2
SELECT * FROM cmis:document WHERE IN_TREE('123456789')
Query result:
document1, document2.