CMIS is an API for interacting mostly with Alfresco; there is a Drupal CMIS module which I have forked and extended: https://github.com/soundasleep/cmis

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.