| Filter |  |
| This topic describes how to use filtering to limit the number of records on your screen. The Filter menu To apply a filter in a session, open the Filter menu. To do this, complete one of the following steps: On the session's View(s) menu, click Filter. Click the icon. The Filter menu contains the following options: Advanced Filtering Save As None Easy Filtering Instant Filtering Match Case The menu also displays the filters you saved. Advanced Filtering To delete or modify a saved filter, click Advanced Filtering. The Filters (ttadv9593m000) session starts. In this session, you can delete the filter or set additional filter options to refine the filter. For details, refer to the session help. Save As Select this option to save the currently active filter. None Select this option to disable the currently active filter. Easy Filtering You can enter filter criteria in the input fields above the grid. On alphanumeric fields, you can specify the wildcards * or ?. On alphanumeric fields and on numeric fields, you can specify the operators >, <, <=, >=, <>. You should not specify operators and wildcards in the same field. On date fields, it is possible to use a relative date, for example –7 showing records with a date of 7 days ago. You can also perform advanced filtering: filter a particular value, and then refine your filter by setting a new value on the filtered data. Note The number of fields for which easy filtering is available, depends on ERP LN configuration settings. See the online help of the Maintain Parameters (ttaad0100m000) session. Instant Filtering Instant Filtering means that the filter will be applied immediately when you tab out of a field in the easy filter area. You can switch Instant Filtering on or off in the Filter menu. If Instant Filtering is switched off then the filter will be applied when you press ENTER in the easy filter area, or when you leave the easy filter area. Match Case Select this option to make the filter case sensitive. Example You switched on the Match Case option, and you enter the filter value "ABC" for a column. The session only displays records where the column contains "ABC" in uppercase. Records where the column contains, for example, "abc" or "Abc", are hidden. You can switch Match Case on or off in the Filter menu. |