You are here: Transaction Rules > Transaction Elements > Math Elements > COLLECTION and KEY

COLLECTION and KEY

Description

This math element is used to execute a SQL statement that will return two result columns as a key-value pair. The first column is considered the key with the second column a value. A subsequent statement of type COLLECTIONVALUE is used to access the key to retrieve its associated value

COLLECTION and KEY Element/Attribute Table

TYPE=COLLECTION KEY=GUID
Element	Attribute	Attribute Value	Element Value
<MathVariable>	TYPE	COLLECTION	SQL statement. The data type is always MAP.

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>