REPEAT (REP, R) (Selection Criteria)

This command is available in the Selection Criteria function in Formatted mode.

The REPEAT command inserts a copy of the current selection criteria set after the current criteria. REPEAT by itself copies a whole set, including any subsets. REPEAT AND copies only the current subset.

For REPEAT by itself, the number of criteria sets or subsets is incremented (SET 3 of 3 increments to SET 4 of 4; AND SET 3.2 of 3 increases to AND SET 4.2 of 4) and the newly inserted set or subset is presented for editing; each field in the layout is set to the same values as the copied criteria. A confirmation message appears: SELECTION LEVEL INSERTED.

Any set you specify by completing the RO and data value for one or more fields will be ORed with all other criteria sets.

There must be at least one condition specified on the current criteria set or subset before you may REPEAT another set or subset.

AND

Inserts a copy of the current set or subset of selection criteria after the current subset as an ANDed subset. The criteria set number is NOT incremented but the subset number is (AND SET x.y of z (e.g. SET 3.3 of 4).). The newly created subset is presented for editing, with each field in the layout set to the same values as the copied criteria. A confirmation message appears: SELECTION LEVEL INSERTED. Any conditions you specify by completing the RO and data value for one or more fields will be ANDed with the other subsets. There must be at least one condition specified on the current criteria set before you may use REPEAT AND for another subset.

The number of subsets is limited to 255 for any one SET.

Guidelines

Multiple fields for a single criterion test are logically ANDed together, multiple AND subsets are ANDed together, and multiple sets of criteria tests are logically ORed together.

Each ANDed Subset is processed as a part of the preceding Set as a group of conditions. An OR Set represents a new group of conditions. Consider the following Sets:

This criteria will be processed as (SET 1) OR (SET 2.1 AND SET 2.2) OR SET 3.