Query: Select all folders that are in folder1.
Initial data:
folder1: id - 123456789
document1: Title - node1
folder3:
folder4:
folder2:
document2: Title - node2
SELECT * FROM cmis:folder WHERE IN_FOLDER('123456789')
Query result:
folder3.