Column filter operators are used to define how to apply a filter to a data list with regard to the value specified in the column's filter drop-down list.
Operators are available by clicking the operator button:
Depending on the type of value the column contains, the following operators may be available:
|
Operator |
Description |
|---|---|
|
Equals |
Values equal to the value specified in the corresponding drop-down list are displayed. |
|
Not equals |
Values not equal to the value specified in the corresponding drop-down list are displayed. |
|
Less than |
Values less than the value specified in the corresponding drop-down list are displayed. |
|
Less than or equal to |
Values less than or equal to the value specified in the corresponding drop-down list are displayed. |
|
Greater than |
Values greater than the value specified in the corresponding drop-down list are displayed. |
|
Greater than or equal to |
Values greater than or equal to the value specified in the corresponding drop-down list are displayed. |
|
Contains |
Any values containing the value specified in the corresponding drop-down list are displayed. |
|
Does Not Contain |
Any values containing the value specified in the corresponding drop-down list are not displayed. |
|
Top |
The top number of values specified in the corresponding drop-down list are displayed. For example, when Top is selected and 2 is entered in the ID column drop-down list in the Users layout, the two most recently created users are displayed. |
|
Bottom |
The bottom number of values specified in the corresponding drop-down list are displayed. For example, when Bottom is selected and 2 is entered in the ID column drop-down list in the Users layout, the two users created first (ADMINISTRATOR and MANAGER) are displayed. |
|
Top percentile |
Values in the top percentile of the value specified in the corresponding drop-down list are displayed. |
|
Bottom percentile |
Values in the bottom percentile of the value specified in the corresponding drop-down list are displayed. |
|
Like (wildcards) |
Values like (including wildcards) the value specified in the corresponding drop-down list are displayed. |
|
Not like (wildcards) |
Values that are not like the value (including wildcards) specified in the corresponding drop-down list are displayed. |
|
Match (regular expression) |
Values that match (including regular expression) the value specified in the corresponding drop-down list are displayed. For example, typing A*M in the Name column in the Users layout displays the MANAGER and ADMINISTRATOR user names, because both user names contain the letters A and M. |
|
Does not match (regular expression) |
Values that do not match (including regular expression) the value specified in the corresponding drop-down list are displayed. |
|
Starts with |
Values that start with the value specified in the corresponding drop-down list are displayed. |
|
Does not start with |
Values that do not start with the value specified in the corresponding drop-down list are displayed. |
|
Ends with |
Values that end with the value specified in the corresponding drop-down list are displayed. |
|
Does not end with |
Values that do not end with the value specified in the corresponding drop-down list are displayed. |
|
In |
This option is intended for use with Reporting Dashboards. For more information, see the Reporting Dashboards module reference guide. |
|
Not In |
This option is intended for use with Reporting Dashboards. For more information, see the Reporting Dashboards module reference guide. |