Operators

The operators to use for filtering are broken down into the following categories:

String: String operators are used when the data to be filtered is stored as character strings in the database.
Note: Columns that appear to be numeric may actually be stored as character strings in the database.
Numeric: Numeric operators are used when the data to be filtered is stored as numeric values in the database.
Static Search: Static search operators are used when there is a defined set of search terms available for the column. The user may only select the search term from a predefined list.