Boolean functions

• Latest Dynatrace
• Reference
• Updated on Aug 12, 2024

Functions that evaluate boolean expressions and test the presence of values.

isFalseOrNull

Evaluates if an expression is false or null.

Syntax

isFalseOrNull(expression)

Parameters

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:

isNotNull

Tests if a value is not null.

Syntax

isNotNull(expression)

Parameters

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:

isNull

Tests if a value is null.

Syntax

isNull(expression)

Parameters

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:

isTrueOrNull

Evaluates if an expression is true or null.

Syntax

isTrueOrNull(expression)

Parameters

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: