Sunday, 21 April 2019

openCMIS: Query Comparison operators


Operator
Description
Applicable to
< 
a < b : Condition true if a is less than b, else false.
DateTime, Decimal, Integer
<=
a <= b : Condition true if a is less than or equal to b, else false.
DateTime, Decimal, Integer
> 
a > b : Condition true if a is greater than b, else false.
DateTime, Decimal, Integer
>=
a >= b : Condition true if a is greater than or equal to b, else false.
DateTime, Decimal, Integer
=
a=b : Condition true if a is equal to b, else false
DateTime, Decimal, Integer, ID, String, URI, Boolean
<> 
a <> b : Condition true if a is not equal to b, else false
DateTime, Decimal, Integer, ID, String, URI

Select all the documents, where cmis:name is ‘a.txt’
SELECT * FROM cmis:document where cmis:name='a.txt'



Previous                                                 Next                                                 Home

No comments:

Post a Comment