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
Parameter | Type | Description | Required |
---|---|---|---|
expression | boolean | required |
Returns
The data type of the returned value is boolean
.
Examples
Example 1
data record(value = true),record(value = false),record(value = null),record() // field does not exist| fieldsAdd isFalseOrNull(value)
Query result:
value | isFalseOrNull(value) |
---|---|
|
|
|
|
null |
|
null |
|
isNotNull
Tests if a value is not null
.
Syntax
isNotNull(expression)
Parameters
Parameter | Type | Description | Required |
---|---|---|---|
expression | array, boolean, double, duration, ip, long, record, string, timeframe, timestamp | required |
Returns
The data type of the returned value is boolean
.
Examples
Example 1
data record(value = true),record(value = false),record(value = "DQL is awesome!"),record(value = null),record() // field does not exist| fieldsAdd isNotNull(value)
Query result:
value | isNotNull(value) |
---|---|
|
|
|
|
|
|
null |
|
null |
|
isNull
Tests if a value is null
.
Syntax
isNull(expression)
Parameters
Parameter | Type | Description | Required |
---|---|---|---|
expression | array, boolean, double, duration, ip, long, record, string, timeframe, timestamp | required |
Returns
The data type of the returned value is boolean
.
Examples
Example 1
data record(value = true),record(value = false),record(value = "DQL is awesome!"),record(value = null),record() // field does not exist| fieldsAdd isNull(value)
Query result:
value | isNull(value) |
---|---|
|
|
|
|
|
|
null |
|
null |
|
isTrueOrNull
Evaluates if an expression is true
or null
.
Syntax
isTrueOrNull(expression)
Parameters
Parameter | Type | Description | Required |
---|---|---|---|
expression | boolean | required |
Returns
The data type of the returned value is boolean
.
Examples
Example 1
data record(value = true),record(value = false),record(value = null),record() // field does not exist| fieldsAdd isTrueOrNull(value)
Query result:
value | isTrueOrNull(value) |
---|---|
|
|
|
|
null |
|
null |
|