Find/Filter By

Application Basics > Common Functions > Common Work Area Controls > Find/Filter By

Find/Filter By

You can search for records and filter by records in a grid by using the Find/Filter By box and controls.

The Find/Filter By box and controls are available on most pages.

Action

Description

Left Filter Box

Select the arrow to display a drop-down list of columns. The column you select is the column that will be filtered.

Only columns configured for the grid appear in the drop-down list.

Right Filter Box

Enter a value in this field to use as the search criteria.

Click this icon to initiate the search.

This control is not always presented on the page. Some pages initiate the search by pressing Enter.

For example, if Part was selected in the filter box and 1P1 was entered in the text box, then the first match of 1P1 is highlighted on the page.

Click the find button (

) again to highlight the next matching record.

Click this icon to filter the page by the selection criteria.

This control is not available on every page.

The records that match the selection criteria are displayed on the page. All non-matching records are hidden from the display.

For example, if Part was selected in the filter box and 1P1 was entered in the text box, then the results listed on the page would be filtered to only show records where the Part is equal to 1P1.

Click this icon to clear the filter criteria.

This control is only displayed when a filter is applied.

Tips for Entering Successful Search Criteria

Use the following guidelines to help you construct useful search criteria:

1. Do not use single quotation marks (') or double quotation marks (") when entering a search value. Quotation marks are considered a legitimate part of the string value.

2. Use relational operators to search for records by specific values or range. The following relational operators can be used at the beginning of a filter selection rule for numeric values:

Operator

Action

Finds entries that are an exact match to the value entered.

This also works for a character string. For example, to find the exact text NY1 in a field, you would enter =NY1 as the find/filter field value.

Finds entries that are not equal to the value entered.

Finds entries that are greater than or equal to the value entered.

Finds entries that are less than or equal to the filter value entered.

Finds entries that are greater than the value entered.

Finds entries that are less than the filter value entered.

3. Use the following boolean values:

Case is ignored when using a boolean value in the search string.

Value	Action
true	Filters for true, yes, y, and 1
false	Filters for false, no, n, and 0