Rules for Setting Filters
Use any of the following operators to filter information in a view:
|
Operator |
Description |
|
> |
greater than |
|
< |
less than |
|
= |
equals; the default |
|
~ |
not equal to |
|
<> |
not equal to |
|
!= |
not equal to |
|
! |
not equal to |
|
>= |
greater than or equal to |
|
<= |
less than or equal to |
Note: No operator implies the equal to (=) character. The filtered results are the same whether you specify the = operator or not, for example, both =ABC and ABC are the same.
Valid wildcard characters are asterisk (*), percentage (%), and question mark (?).
-
Asterisk (*)
Use an asterisk at the beginning, middle, or end of a string to indicate the minimum acceptable string. Examples are provided next:-
*XYZ displays anything that ends with the characters XYZ, regardless of what the string begins with.
-
ABC*XYZ displays anything that begins with ABC and ends with XYZ, regardless of how many characters are in between.
-
-
Percent (%)
Use a % sign to indicate that the position must be occupied by a number; for example:
The filter criterion XYZ%% displays all instances of XYZ followed by two numbers. XYZ30 and XYZ42 satisfy the condition, but XYZ173 and XYZ2A do not. -
Question mark (?)
Use a question mark to indicate that a given position must be occupied by any character, regardless of its type.
The filter JOB?A% displays all jobs that have JOB in the first three positions, any character in the fourth, an A in the fifth, and a number in the last position. JOB1A6 and JOB#A7 are displayed, but JOB1Z is not.
If you use a wildcard within a numeric value, that number is treated as a character string. For example, you can use the filter ??9 to filter a field to show only three-digit numeric values that end with the number 9.Note: If filters are established for multiple columns in a view, all conditions must be satisfied for the data to appear.
More Information: