Sample Query to check Is Null in Cosmosdb:

SELECT * FROM c where IS_NULL(c.demoCycleId)=false

Below are list of type checking functions available:

IS_ARRAY (expr)

IS_BOOL (expr)

IS_NULL (expr)

IS_NUMBER (expr)

IS_OBJECT (expr)

IS_STRING (expr)

IS_DEFINED (expr)

IS_PRIMITIVE (expr)

 

Advertisements