Navigator User Guide

10.5.1
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Step 2. Filter the Data in the Data Map

Record IDs provide a filtering mechanism at run-time, eliminating the need for SQL statements to select the desired records.

On the

Data Map

tab in the

Resource Explorer

, click

record1

In the

Record

window, right-click the

rectype

field and click

Properties

The

Field Properties

dialog box appears.

In the

Record ID Values

list, click the

button to select the operators for filtering the data. The record IDs 10 and 20 combined with the operator setting determine which data appears. Complete one of the following actions:

Click the

button to display records with a record ID value equal to either 10 or 20. In the

Database Row Test Output

window, any record with a record ID that is not equal to 10 or 20 does not appear.

Click the

button to display records with a record ID value that is greater than or less than but not equal to 10 or 20.

The data map stores the record IDs but not the data. Record ID fields might not be displayed in the column view of the data. You cannot use record ID filtering on WRITE.

Rename Saved Search

Table of Contents

Navigator User Guide

Navigator User Guide

Step 2. Filter the Data in the Data Map

Step 2. Filter the Data in the Data Map