2021:CMISQL Query: Difference between revisions

Revision as of 09:44, 31 May 2022

CMIS Queries are utilized to search documents in CMIS Repositories and to filter documents upon import when using the Import Query Results provider.

Also called a "CMISQL query", the querying language CMIS Queries use is based on a subset of the SQL-92 grammar. Where SQL is a querying language to search and select data in a database, "CMISQL" is a querying language to search and select documents (and their metadata properties) in a storage location, represented by a CMIS Repository in Grooper.

About

CMIS Queries use clauses to retrieve content from a CMIS Repositories based on certain metadata property values, much like a SQL query uses clauses to retrieve data from a database based on column values. In both cases, a SELECT clause is used to select content based on certain conditions determined by a WHERE clause

In general the CMISQL statement takes the following form:

SELECT * FROM <Object Type> WHERE <Conditions> ORDER BY <Sort Criteria>

@@ Line 9: / Line 9: @@
 '''''CMIS Queries''''' use clauses to retrieve content from a '''CMIS Repositories''' based on certain metadata property values, much like a SQL query uses clauses to retrieve data from a database based on column values.  In both cases, a <code>SELECT</code> clause is used to select content based on certain conditions determined by a <code>WHERE</code> clause
-In gen
+In general the CMISQL statement takes the following form:
+<code><span style="color:blue">SELECT</span> * <span style="color:blue">FROM</span> <Object Type> <span style="color:blue">WHERE</span> <Conditions> <span style="color:blue">ORDER BY</span> <Sort Criteria></code>