Using Effective Date Operator in the Connected Query Manager Page

Effective date operator is available in the Connected Query Manager page as a part of the field mapping process. You can select an effective date operator for any of the member queries if a child query has an EFFDT value selected as a related field.

This example shows the Connected Query Manager page and the Eff Date Operator (effective date operator) list.

Note that the effective date operator list:

• Is available only if a selected field has a format of EFFDT.

• Is available in the Connected Query Manager but not available in the Connected Query Quick Start.

• Has a default operator—an equal operator—like other fields.

• Need not be saved in the database before you preview the XML of a connected query.