Purpose
Return attributes for an item with three parts.
Assumptions
There is one attribute normal group (in the expression), defined as follows.
|
Order Card |
Attributes include A, C. |
There is one attribute list group (in the expression), defined as follows.
|
Parts |
Attributes include quantity. |
Query Expression 1
Order Card.A;Parts.quantity;Order Card.C,3,2
Where
|
Criteria |
Is/are the: |
|
A |
Order card attribute |
|
quantity |
List group attribute |
|
C |
Order card attribute |
Important: This expression is for demonstration
only. It shows how Index numbers are used.
However, it is not useful because it fails to display what quantity
goes with what part.
Query Expression says:
Return values as follows:
All the values for A attribute.
Quantity of parts in the parts
list.
C attribute value characters in positions 3
and 4.
Query Expression Results
The results come back in a 2-dimensional array with 5 rows.
The columns are:
A 0 based index in the first column.
Returned values in the second
column.
Five indexed rows correspond to
the expression's returned values.
The results for the above attribute list might look like this:
|
0 |
DFG7 J3356F5CS |
|
1 |
45 |
|
1 |
55 |
|
1 |
1 |
|
2 |
G9 |
The indexed rows relate to the expression as follows.
|
Expression |
Index |
Result |
|
Order Card.A |
0 |
DFG7 J3356F5CS |
|
Parts.quantity |
1 |
45 |
|
Parts.quantity |
1 |
55 |
|
Parts.quantity |
1 |
1 |
|
Order Card.C,3,2 |
2 |
G9 |
Quantities are returned for three parts. The results do not tell what the parts are.
|
|
Order Execution Mgt. Query expression descriptions. |
