Show/Hide All

 Overview

Use this procedure to filter the records that appear in the Key Scan window.

To filter the records that appear in the Key Scan window

1. Select Library Master Utilities menu > Data File Display and Maintenance.

2. In the File Name field, select a data file. For more information, see Data File Display and Maintenance - Fields.

3. Click Fields.
4. In the Select Fields window, select the fields that you want to appear. Press Ctrl to select multiple fields. Click OK when finished.
5. In Data File Display and Maintenance, click the Filter button ( ).
6. In the Filter window, for the field with data that you're going to filter, select an operator. For more information, see Filter - Fields.

7. In the Data Value field, enter a value to work with the selected operator, and then click OK.

   Example

   If you've select the AR_Customer file, and you want to view records for customers in California, enter the following for the State$ field:

   Operator: Equal

   Data Value: CA

   Note that you cannot enter multiple values in the Data Value field.

8. In Data File Display and Maintenance, click the Key Scan button ( ).

The Key Scan window opens and displays records filtered based on the criteria that you entered.