Troubleshooting and Reference Guide > Troubleshooting and Reference Guide > Available Functions > Using Core Functions > Predicate Functions
Was this helpful?
Predicate Functions
The Predicates category provides implementations of common boolean and logical functions. These functions can also be combined to construct more complex predicates. Values to the predicate functions may be provided as field names or as scalar functions that return values to compare.
Predicates are commonly used in conjunction with Using the FilterRows Operator to Filter by Predicate.
Function Name
RushScript Symbol
Description
Output Type
Parameters
Predicates.and
and
Logical AND of the given predicate expressions.
boolean
List of boolean valued expressions
Predicates.eq
=
Tests the equality of two values. The input values must be of comparable types.
boolean
• First input value
• Second input value
Predicates.gt
>
Tests if the first value is greater than the second value. The input values must be of comparable types.
boolean
• First input value
• Second input value
Predicates.gte
>=
Tests if the first value is greater than or equal to the second value. The input values must be of comparable types.
boolean
• First input value
• Second input value
Predicates.isFalse
is false
Tests if the value is false.
boolean
Input boolean value
Predicates.isNull
is null
Tests if the input value is null.
boolean
Input value
Predicates.isTrue
is true
Tests if the value is true.
boolean
Input boolean value
Predicates.like
like
Tests whether the input value matches a specified SQL LIKE pattern. The input value must be a String.
boolean
Input string value
Predicates.lt
<
Tests if the first value is less than the second value. The input values must be of comparable types.
boolean
• First input value
• Second input value
Predicates.lte
<=
Tests if the first value is less than or equal to the second value. The input values must be of comparable types.
boolean
• First input value
• Second input value
Predicates.matches
 
Tests whether the value of a field matches a specified regular expression. The input value must be a String.
boolean
• Input string value
• Regular expression
Predicates.neq
!=
Tests the inequality of the input values. The input values must be of comparable types.
boolean
• First input value
• Second input value
Predicates.not
not
Logical negation of the input boolean value.
boolean
Input boolean value
Predicates.notFalse
is not false
Tests whether the input value is not false.
boolean
Input boolean value
Predicates.notNull
is not null
Tests if the input value is not null.
boolean
Input value
Predicates.notTrue
is not true
Tests whether the input value is not true.
boolean
Input boolean value
Predicates.or
or
Logical OR of the given predicate expressions.
boolean
List of boolean valued expressions
Last modified date: 01/06/2023