se 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 Full text search reference.
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