The WHERE and ORDER BY clauses support the following property data types and comparisons:
-
string
- Supports all properties and comparisons, such as =, <>, <, <=, >=, >, IN, NOT IN, LIKE
-
Supports ordering for single-valued properties For example:
select * from cmis:documentwhere cmis:name <> 'fred' orderby cmis:name
-
integer
- Supports all properties and comparisons, such as =, <>, <, <=, >=, >, IN, NOT IN
- Supports ordering for single-valued properties
-
double
- Supports all properties and comparisons, such as =, <>, <, <=, >=, >, IN, NOT IN
- Supports ordering for single-valued properties
-
float
- Supports all properties and comparisons, such as =, <>, <, <=, >=, >, IN, NOT IN
- Supports ordering for single-valued properties
-
boolean
- Supports properties and comparisons, such as = and <>
- Supports ordering for single-valued properties
-
id
- Supports cmis:objectId, cmis:baseTypeId, cmis:objectTypeId, cmis:parentId, =, <>, IN, NOT IN
- Ordering using a property, which is a CMIS identifier, is not supported
-
datetime
- Supports all properties and comparisons =, <>, <, <=, >=, >, IN, NOT IN
-
Supports ordering for single-valued properties For example:
select * from cmis:documentwhere cmis:lastModificationDate = '2010-04-01T12:15:00.000Z' orderby cmis:creationDate ASC
Note: While the CMIS URI data type is not supported,
multi-valued properties and multi-valued predicates as defined in the CMIS
specification are supported. For example, select * from
ext:doc where 'test' = ANY ext:multiValuedStringProperty