You are looking at documentation for an older release. Not what you want? See the current release documentation.
To enable query support, follow CMIS Add-on configuration section.
The service URL is http://localhost:8080/rest/private/cmisatom/{repositoryId}/query. To use curl to send request (GET and POST), see Simple query section.
CMIS provides a type-based query service for discovering objects that match specified criteria by defining a read-only projection of the CMIS data model into a Relational View.
CMIS query languages are based on a subset of the SQL-92 grammar. CMIS-specific language extensions to SQL-92 are called out explicitly. The basic structure of a CMIS query is a SQL statement that MUST include the following clauses:
SELECT (virtual columns): This clause identifies the set of virtual columns that will be included in the query results for each row.
FROM (Virtual Table Names): This clause identifies which Virtual Table(s) the query will run against.
Additionally, a CMIS query MAY include the following clauses:
WHERE (conditions): This clause identifies the constraints that rows MUST satisfy to be considered a result for the query.
ORDER BY (sort specification): This clause identifies the order in which the result rows MUST be sorted in the result row set.
Each CMIS ObjectType definition has the following query attributes:
| Name | Description |
|---|---|
| query name (String) |
Is used for query operations on object types. In the SQL statement examples, all object types are queryName. For example,
the given queryName matches the specific type of document. For example, in query like " |
| queryable (Boolean) |
Indicates whether or not this object type is queryable. A non-queryable object type is not visible through the relational view that is used for query, and can not appear in the FROM clause of a query statement. |
| fulltextIndexed (Boolean) |
Indicates whether objects of this type are full-text indexed for querying via the |
| includedInSupertypeQuery (Boolean) |
Indicates whether this type and its subtypes appear in a query of this type's ancestor types. For example, if Invoice is a sub-type of Document, and its value is TRUE for a query on Document type, the matched instances of Invoice will be returned. If this attribute is FALSE, no instances (including matched ones) of Invoice will be returned. |
Property definition also contains queryName and queryable attributes with the same usage.