Use Query By Example

Query By Example is the row of fields that precedes the table column headers, used for filtering the data in the table.

Applying the Query By Example Filter

Follow these steps:

1. Click Query By Example on the table toolbar if the row of fields isn't displayed.

2. Enter filter values in any or all of the Query By Example fields.

3. Press Enter.

The table now shows only the records that meet the criteria you entered in all Query By Example fields.

Refreshing the Filtered Results

Do any of the following tasks:

• Press Enter again with your cursor in any of the Query By Example fields.

• Click Search or Refresh on the toolbar, if available.

• Select Refresh from the View menu, if available.

Note: The filter applies even if the Query By Example fields are hidden.

Removing the Query By Example Filter

Click the Clear All icon at the beginning of the Query By Example row, if available.

If not, then follow these steps:

1. Delete what you entered in each Query By Example field.

2. Refresh the table.

To clear not just Query By Example but any other table filters:

1. Select Clear from the View menu or click Clear on the table toolbar, if available.

2. Refresh the table.