Previous Topic: Specify Attribute Conditions for a READ EACH ActionNext Topic: Detail Properties of a READ EACH Statement


Specify Relationship Conditions for READ EACH

Like attribute conditions, the same relationship conditions apply to the READ and the READ EACH actions.

The following examples show how relationship conditions are used in Action Diagrams. The first example reads each CUSTOMER ORDER pair where the customer placed the order for the current occurrence of PRODUCT; it also reads any ORDER(s) placed for that PRODUCT:

READ EACH customer
order
WHERE DESIRED customer places DESIRED order
AND DESIRED order contains SOME order line
AND THAT order_line is for CURRENT product

The next example shows a fully defined READ EACH statement that targets a repeating group view:

READ EACH issue
status
TARGETING out_group FROM THE BEGINNING UNTIL FULL
SORTED BY ASCENDING issue number
WHERE DESIRED issue_status is_contained_in
CURRENT design_development
AND (DESIRED issue_status status IS EQUAL TO "Q"
OR DESIRED issue_status status IS EQUAL TO "T"
OR DESIRED issue_status status IS EQUAL TO "N")
MOVE issue_status to output issue_status
MOVE issue TO output issue

More information:

Specify Relationship Conditions for a READ Action