# Alfresco Platform

 The Alfresco driver exposes the alfresco table in order to pass queries to the Alfresco Search SQL API. The driver supports translating most SQL-92 queries into the SQL syntax required by the Alfresco Search SQL API. However, syntax limitations and incompatibilities do exist. A full overview of the capabilities and restrictions of the Search SQL API syntax is maintained in Alfresco documentation, but important syntax requirements and limitations for the API and driver are documented below:

1. The aggregation functions COUNT(\*), SUM(numeric\_field), AVG(numeric\_field), MAX(numeric\_field), and MIN(numeric\_field) are supported. The COUNT(specific\_field) or COUNT(DISTINCT specific\_field) aggregations are unsupported.
2. HAVING can only be applied to aggregation functions.
3. LIKE, JOIN, and UNION are unsupported.
4. Sub-queries are not supported.
5. The following should be used in place of an IS NULL filter: where cm\_content != '\*'. The following should be used in place of an IS NOT NULL filter: where cm\_content = '\*'.
6. The CMIS Query Language functions IN\_TREE, IN\_FOLDER, SCORE, and CONTAINS are unsupported.

 

###


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.appstrategy.com/apprules-r-documentation/platform/platform-features/system-settings/data-sources/sql-compliance/applicationplatforms/alfresco.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.