| # Easy filtering Easy filtering allows you to enter filter criteria on the column headings of an overview session. Note Easy filtering is available only in the WebTop client. To start easy filtering To make easy filtering available, on the View menu, point to Filter, and then click Easy Filtering. Alternatively, click the button. Filter fields appear in each column heading. If you activate Instant Filtering, the filtering criteria immediately take effect. If you deactivate Instant Filtering, the filtering criteria take effect after you leave the filter area. To define a filter To define a filter on a column, enter a value in the filter field on the column heading. Optionally, you use filter operators in a filter value. Example The Addresses (tccom4530m000) session has a City Description field. If you enter `Casablanca` in this filter field, the session displays only the addresses with the City Description field "Casablanca". Operators in filter fields Fields with codes and textual values On columns with codes and textual values, the filter selects all records with values that start with the value of the filter field. This selection is not case sensitive. Example If you enter `c` in the filter field for the City Description column, the session displays all records with a value for the City Description field that starts with the letter C, such as, Cairo, Canberra, Caracas, Chicago. Wildcards On columns with codes and textual values, you can use filters with wildcards. You can use the following wildcard symbols:
? | Represents any character
* | Represents a series of arbitrary characters.
Example The filter value `TZ?03` selects `TZA03`, `TZB03`, `TZC03`, and so on. The filter value `A*B` selects all values that start with `A`, followed by zero or more arbitrary characters, followed by `B`, (optionally followed by more characters). The > and < operators On columns with codes and textual values, you can use the >, <, <=, >=, and <> operators. These operators are used as follows:
`>TEXT` | Selects values that come alphabetically after TEXT.
`>=TEXT` | Selects the value TEXT and all values that come alphabetically after TEXT.
`<TEXT` | Selects values that come alphabetically before TEXT.
`<=TEXT` | Selects the value TEXT and all values that come alphabetically before TEXT.
`<>TEXT` | Selects all values that do not start with TEXT.
Note Filter operations with these operators are case sensitive. Fields with numeric values On columns with numeric values, you can use the >, <, <=, >=, and <> operators. These operators are used as follows:
`>123.450` | Selects values that greater than 123.45.
`>=123.450` | Selects values that greater than or equal to 123.45.
`<123.450` | Selects values that less than 123.45.
`<=123.450` | Selects values that less than or equal to 123.45.
`<>123.450` | Selects all values that are unequal to 123.45.
Fields with date values Click the calendar icon, to open the calendar and select a date. You can enter relative dates. For example, `-7` represents one week ago and `+2` represents the day after tomorrow. For more information, refer to the online Help of the Web UI, under Working with Infor ERP. Related topics Overview of filters |