12. Nested Relationship Expression using TADB Attribute Lists

Purpose

Return values based on nested relationships between items.

Assumptions

  1.  There are two Item types (in the expression), defined as follows

Order

Invoice information includes what the customer wants.

Customer

Information includes Address group and billing.

  1. There is one Attribute group (in the expression), defined as follows.

Address

Attributes include State.

Query Expression

GetValues(“Component1”,”Order{Customer{Address.State}}”)

Where

Criteria

Is/are the:

GetValues

Expression command to return values.

Component1

Body component

State

Address group attribute

Query Expression says:

Return the state (address) for the customer that Component1 will go to when the customer's associated order is filled.

More information

Order Execution Mgt. Query expression descriptions.