The Files CMIS API imposes some query restrictions on the CMIS query specification.
The CMIS Specification describes a type-based query service using a SQL-92 subset with extensions in Section 2.1.10
. The Files CMIS API imposes the following additional restrictions:
- Queries do not support multivalued properties
- Queries can include zero or one IN_FOLDER condition in the WHERE clause. More than one would cause a JOIN operation which is not supported in this version.
- Queries cannot include both CONTAINS and an OR condition in the WHERE clause, which would cause a JOIN operation.
Parent topic: Files CMIS API extensions