Filter a Table Window

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.

To filter a table window:

  1. Click the Filter. The filter opens and Filter Table appears.

  2. 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.

  1. 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."

  1. 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.

See Also

Table Window Buttons

View Information

Download Table Window Data