Transactional metadata queries supported by database - Transactional metadata queries supported by database - Alfresco - Alfresco Search Enterprise - Alfresco/Alfresco-Search-Enterprise/4.2/Alfresco-Search-Enterprise/Configure/Transactional-metadata-query/Transactional-metadata-queries-supported-by-database - 4.2 - 4.2

Alfresco Search Enterprise

Platform
Alfresco
Product
Alfresco Search Enterprise
Release
4.2
License
ft:lastPublication
2026-10-22T08:26:09.664000
ft:locale
en-US

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