Functions that evaluate boolean expressions and test the presence of values.
Evaluates if an expression is false or null.
isFalseOrNull(expression)
| Parameter | Type | Description | Required |
|---|---|---|---|
expression | boolean | Required |
The data type of the returned value is boolean.
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 |
|
Tests if a value is not null.
isNotNull(expression)
| Parameter | Type | Description | Required |
|---|---|---|---|
expression | array, boolean, double, duration, ip, long, record, string, timeframe, timestamp | Required |
The data type of the returned value is boolean.
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 |
|
Tests if a value is null.
isNull(expression)
| Parameter | Type | Description | Required |
|---|---|---|---|
expression | array, boolean, double, duration, ip, long, record, string, timeframe, timestamp | Required |
The data type of the returned value is boolean.
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 |
|
Evaluates if an expression is true or null.
isTrueOrNull(expression)
| Parameter | Type | Description | Required |
|---|---|---|---|
expression | boolean | Required |
The data type of the returned value is boolean.
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 |
|