Oracle® Rules Palette Release 9.1.0.0.0 E15811-01

# COLLECTION and KEY

## Description

This is used to run a SQL statement to return a collection of values paired with a key. The first column returned contains the KEY value and the second column the associated value. Then the COLLECTIONVALUE type can be used to access the collection.

## COLLECTION and KEY Element/Attribute Table

TYPE=COLLECTION KEY=GUID
Element | Attribute | Attribute Value | Element Value
<MathVariable> | TYPE | COLLECTION | SQL statement.

## XML Example

<MathVariable VARIABLENAME="FundGUIDs" TYPE="COLLECTION" DATATYPE="MAP">SELECT AsFundField.TextValue, AsFund.FundGUID FROM AsFund WHERE AsFundField.FieldName = 'FundID' AND AsFundField.TextValue IN ('1600','1601','1602')</MathVariable>