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
array_contains	Returns true if array arr contains a value equal to val, where val is of variant type.
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	Test whether an IPv4 address is in a given 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.
same	Return true if A is the same as B.
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.