Tables may contain a large number of rows. Table windows include a filter to help you locate specific rows in large tables by reducing the number of rows displayed. In some cases you may be required to reduce the size of a large result set before performing an action.
This filter remains hidden until you click Filter.
When clicked,
the filter opens as a row of editable fields between the table column
headers and the first row of the table.
Click the Filter. The filter
opens and Filter Table
appears.
Enter a value in one or more of the filter fields.
Tip: Use the equals sign (=) for an exact match. For example, filtering records with a status of "APPR" will also return records that are WAPPR unless you type "=APPR" in the status field.
Click Filter
Table .
The system filters the table window and Clear Filter Fields
appears.
If there are no rows that match your filter criteria, a message displays in the table window, for example "No work orders found."
To filter using
different criteria, click Clear Filter Fields to
return to the original result set.
Note: Clear
Filter Fields only appears when a table has been filtered.