CMIS query

• SELECT with a target list
• FROM with the object types being queried
• JOIN to perform a join between object types
• WHERE with the predicate
• IN and ANY to query multi-value properties
• CONTAINS to specify a full-text qualification
• IN_FOLDER and IN_TREE to search within a folder hierarchy
• ORDERBY to sort the results

The CMIS query maps the object type into a relational structure where object type approximates a table, the object approximates a row, and the property approximates a column that can be multi-valued. You can query the actual binary content using a full text query and folder path information using the in_folder and in_tree functions.