RapidIdentity Product Guide: New UI

Filtering Syntax

The basic unit for a filter is a comparison of the form <fieldName><operator><value>.

  • fieldName starts with a letter and may contain letters, digits, underscores, and hyphens.

  • operator can be one of the following:

    • equals: =

    • does not equal: !=

    • like: ~ or like

    • greater than: >

    • greater than or equal to: >=

    • less than: <

    • less than or equal to: <=

  • value is either null or a quoted JSON string.

    • The unquoted form of the JSON string may be used if it does not contain white space, backslash, double quotes, or any symbol used as an operator.

  • Comparisons may be joined with a boolean logical operator where and has higher precedence.

    • and: & or and

    • or: | or or

  • Keyword forms of operators are not case-sensitive.

  • A comparison or set of comparisons joined by logical operators may be enclosed in a pair of parentheses.

  • The not operator (! or not) may precede the opening parenthesis to negate the boolean value of the expression.

  • Insignificant white space may appear anywhere except within a fieldName, operator, or value, but is only required before and after keyword forms of and, or, not, and like operators.