7. Simple Expression for Attribute Lists

Purpose

Display all values for one attribute and values in selected positions for another.

Assumptions

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

Order Card Attributes include A, C.

Query Expression

Order Card.A;Order Card.C,3,2

Criteria Is/are the:
A Order card attribute
C Order card attribute
Note: List of attributes are separated by semi-colons

Query Expression says:

Return the Order Card A attribute and 2 characters from the C attribute value positions 3 and 4.

Query Expression Results

The results come back:

  • In a 2-dimensional array.
  • The columns are:
  • A 0 based index in the first column.
  • Returned values in the second column.
  • Two indexed rows correspond to the expression's returned values.

The results for the above attribute list might look like this:

0 DFG7 J3356F5CS
1 G9

The indexed rows relate to the expression as follows.

Expression Index Result
Order Card.A 0 DFG7 J3356F5CS
Order Card.C,3,2 1 G9

Note: The index column is for when attribute from a list group is requested.