Use this information to understand the queries supported by the database.
The Alfresco Full Text Search (FTS) query text can be used standalone or it can be embedded in CMIS-SQL using the CONTAINS() predicate function. The CMIS specification supports a subset of Alfresco FTS. For more information on search syntax, see the Full Text Search Reference section in the Alfresco Search Services documentation.
CMIS QL
The following object types and their sub-types are supported:
-
cmis:document
For example:
select * from cmis:document -
cmis:folder
For example:
select * from cmis:folder
-
Aspects
For example:
select * from cm:dublincore