Boolean functions
Functions that evaluate boolean expressions and test the presence of values.
isFalseOrNull
Evaluates if an expression is false or NULL.
-
Syntax
isFalseOrNull(expression) -
Parameters
Name Type Mandatory Default Constraints Description expression
boolean
yes
-
Example
1data record(value = true),2 record(value = false),3 record(value = null),4 record() // field does not exist5| fieldsAdd isFalseOrNull(value)Query result
value isFalseOrNull(value) truefalsefalsetruenull
truenull
true
isNotNull
Tests if a value is not NULL.
-
Syntax
isNotNull(expression) -
Parameters
Name Type Mandatory Default Constraints Description expression
array, boolean, double, duration, ip, long, record, string, timeframe, timestamp
yes
-
Example
1data record(value = true),2 record(value = false),3 record(value = "DQL is awesome!"),4 record(value = null),5 record() // field does not exist6| fieldsAdd isNotNull(value)Query result
value isNotNull(value) truetruefalsetrueDQL is awesome!truenull
falsenull
false
isNull
Tests if a value is NULL.
-
Syntax
isNull(expression) -
Parameters
Name Type Mandatory Default Constraints Description expression
array, boolean, double, duration, ip, long, record, string, timeframe, timestamp
yes
-
Example
1data record(value = true),2 record(value = false),3 record(value = "DQL is awesome!"),4 record(value = null),5 record() // field does not exist6| fieldsAdd isNull(value)Query result
value isNull(value) truefalsefalsefalseDQL is awesome!falsenull
truenull
true
isTrueOrNull
Evaluates if an expression is true or NULL.
-
Syntax
isTrueOrNull(expression) -
Parameters
Name Type Mandatory Default Constraints Description expression
boolean
yes
-
Example
1data record(value = true),2 record(value = false),3 record(value = null),4 record() // field does not exist5| fieldsAdd isTrueOrNull(value)Query result
value isTrueOrNull(value) truetruefalsefalsenull
truenull
true