11. Simple Relationship Expression using TADB Attribute Lists

Purpose

Return values based on relationships between items.

Assumptions

  1. There is one Item type (in the expression), defined as follows

Customer

Information includes address and billing.

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

Address

Attributes include State.

Query Expression

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

Where

Criteria

Is/are the:

GetValues

Sub-expression command to return values.

Order1

Order item

State

Address group attribute

Query Expression says:

Return the state address for any customer items that are associated with Order1.

More information

Order Execution Mgt. Query expression descriptions.