OPAL Boolean Functions

Boolean functions calculate logic results, involving “true” and “false.” Note that a null value is neither true nor false; passing a null value to the verb filter will not emit that row in its output.

Function

Description

bool

Generate a boolean value of the argument value.

bool_null

Returns a null value of type bool.

contains

Returns true if the str string contains the expr string (case-sensitive).

ends_with

Returns true if string str ends with string expr.

eq

Return true if A is equal to B.

gt

Return true if A is strictly greater than B.

gte

Return true if A is greater than or equal to B.

in

Returns true if the expression matches with any value in the given set.

ipv4_address_in_network

Given an IPv4 address string in dotted-quad format on the left, and a subnet

is_null

Return true if the argument has the null value.

like

Returns true if subject matches pattern (case-sensitive).

lt

Return true if A is strictly less than B.

lte

Return true if A is less than or equal to B.

match_regex

Return true if the argument input string or object (converted to a string) matches the argument regular expression.

ne

Return true if A is not equal to B.

path_exists

Given a column and path, return whether the JSON path exists in that column.

search

Return true if the for text is matched in the input string in (case-insensitive).

starts_with

Returns true if string starts with expr.