OPAL Boolean Functions

Function

Description

bool

Generate a boolean value of the argument value.

bool_null

Returns a null value of type bool. This is important…

contains

Returns true if the str string contains the expr

ends_with

Returns true if string str ends with string…

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.

is_null

Return true if the argument has the null value.

like

Returns true if subject matches pattern (case-sensit…

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…

ne

Return true if A is not equal to B.

path_exists

Given a column and path, return whether the JSON…

search

Return true if the for text is matched in the…

starts_with

Returns true if string starts with expr.