You are here

Unsupported SQL Commands

Alfresco Search and Insight Engine supports a subset of SQL. Below is a list of commonly used SQL commands that are not currently supported:

Commands
  • CMIS QL functions IN_TREE, IN_FOLDER, SCORE, CONTAINS
  • DATEDIFF
  • DBID Range Queries
  • HAVING : Can only be applied to aggregate functions.
  • JOIN
  • LIKE
  • Multivalued fields
  • String, Math Operators
  • SUB-QUERIES
  • UNION

Sending feedback to the Alfresco documentation team

You don't appear to have JavaScript enabled in your browser. With JavaScript enabled, you can provide feedback to us using our simple form. Here are some instructions on how to enable JavaScript in your web browser.