Selector must be specified for child constraint (IN_TREE) and join
If you are using an IN_TREE child constraint along with a JOIN, you must define which view the IN_TREE constraint applies to:
- SELECT d.*, t.* FROM cmis:document AS d JOIN cm:titled AS t ON d.cmis:objectId = t.cmis:objectId WHERE IN_TREE('folder') is invalid.
- SELECT d.*, t.* FROM cmis:document AS d JOIN cm:titled AS t ON d.cmis:objectId = t.cmis:objectId WHERE IN_TREE(d, 'folder') is valid.
Categories: CMIS