Filtering operators

The operators used for filtering are as follows:

String operators
Numeric operators
Static search term operators

The search term provides a way to narrow down the scope of records while filtering the view. The value of the search term depends on the type of filter selected (string, number, or static choices) and is validated based on that filter type. For example, if the filter option bank is selected, the validation of the search term field verifies that a valid bank ID number was entered. If an invalid search term was entered, the search term field has an X next to it and an error message that provides information about why the search failed appears at the top of the page.

String operators

A predefined set of string operators is shown when the filter selected is represented as a string in the database. Table 1 describes the string operators.

Table 1. String filtering operators
Operator	Description
equal to	Find all records where the search term entered exactly matches the value found in the repository. Note: Search term is not case sensitive.
not equal to	Find all records where the search term entered does not match the value found in the repository. Note: Search term is not case sensitive.
like	Search for a pattern in the filtered field. A "%" is used to define wild cards before and after the pattern.

Numeric operators

A predefined set of numeric operators is shown when the filter selected is represented as a number in the database. Table 2 describes the numeric operators.

Table 2. Numeric filtering operators
Operator	Description
=	Equal to
>	Greater than
<	Less than
> =	Greater than or equal to
< =	Less than or equal to

Static search term operators

A limited set of string operators is shown when the filter value selected works in conjunction with a static set of search term values displayed in a dropdown menu. Search terms can not be edited and the string operator like is not available. Table 3 describes the static search term operators.

Table 3. Static search term operators
Operator	Description
equal to	Find all records where the search term entered exactly matches the value found in the repository. Note: The search term is not case sensitive.
not equal to	Find all records where the search term entered does not match the value found in the repository. Note: The search term is not case sensitive.