You are looking at documentation for an older release. Not what you want? See the current release documentation.
Initial data:
testRoot: id - 123456789
document1: Title - node1 typeID - cmis:article-sports
document2: Title - node2 typeID - cmis:article-animals
SELECT * FROM cmis:article WHERE IN_FOLDER('123456789')
Query result:
document1, document2.