Alphanumeric filters have an operator drop-down box to select the way to use the value. they also have an input box for the value to filter on. The drop-down box is default set to ‘Like’. The options ‘Like’, ‘Not Like and ‘Between’ use Wildcards.
Operator |
Range |
|---|---|
Like. = <> > < >= <= Between. Not Like. |
Allowed Wildcards are: The ‘?’ replaces a character on a specific place. The ‘*’ or ‘%’ will replace any number of Characters. SQL users are used to the % where Windows users tend to use the *.
|
Examples
Filtering on terminal ID:
•Use Q* to list all the Terminal starting with a Q.
•Use ?A* to list all terminals with an A on the second position.
•Use *1* to list all terminals that have a ‘1’ somewhere in its ID.
•Use *1? to list all terminals where the ‘1’ occurs on the second last place.
