CMIS: LIKE and NOT LIKE operators

LIKE and ‘NOT LIKE’ operators are used to compare a value to similar values using wildcard operators. These operators are valid only for following data types.

a.   String

b.   URI

Wild Card	Description
%	Matches zero or more occurrences of any character
_	Matches exactly one character

Get all the documents, whose name ends with .txt

SELECT * FROM cmis:document where cmis:name LIKE '%.txt'

Previous                                                 Next                                                 Home