CMIS: IS NULL and IS NOT NULL Operators

‘IS NULL’ operator is used to check a value with a NULL value.

‘IS NOT NULL’ operator is used to check a value with a non NULL value.

Get all the documents where the cmis:createdBy is not null

SELECT * FROM cmis:document where cmis:createdBy IS NOT NULL   

Previous                                                 Next                                                 Home