CMIS: IN and NOT IN operators

IN and ‘NOT IN’ operators are used to compare a value to a list of literal values that have been specified. These operators are used for following data types.

a.   DateTime

b.   Decimal

c.     ID

d.    Integer

e.    String

f.      URI

Examples

SELECT * FROM cmis:document where cmis:objectId IN ('1', '2', '140')

SELECT * FROM cmis:document where cmis:name IN ('a.txt', 'b.txt')

Previous                                                 Next                                                 Home