INTEGERARRAY
A set of methods, determined by the OPERATION type, that performs math operations on arrays of integer values. Data must be type Integer.
| TYPE=INTEGERARRAY | ||||
|---|---|---|---|---|
| Element | Attributes | Parent Element | Description | Element/Attribute Value |
|
<MathVariable>
|
TYPE |
INTEGERARRAY |
||
|
OPERATION
|
A variable or integer literal whose value is appended to array SOURCEARRAY. |
APPEND |
||
|
COPY |
||||
|
A literal value or math variable whose value is the length of a newly created array. |
CREATE |
|||
|
Use the MULTIPLIER attribute to indicate the number of times each element of the original array should be duplicated. The first and last elements may have a different number of duplicates than the other elements, so this attribute's value can be a comma delimited list of, at most, three values. If only one value is supplied, the others are defaulted to that value. |
EXPAND |
|||
|
The MathVariable element must be a text string containing a FundGUID, and the DATATYPE must be ”INTEGER”. |
FILLBY-BUCKETLIST |
|||
|
Comma separated list of integer constants and/or variable names. |
FILLBY-LIST |
|||
|
A valid SQL statement that returns one or more integer values. |
FILLBY-SQL |
|||
|
FILLBY-STOREDPROCEDURE |
||||
|
A variable or integer literal whose value is to be inserted into the array at INDEX. |
INSERT |
|||
|
REMOVE |
||||
|
A variable or integer literal to replace one or more of the elements of the current array. |
REPLACE |
|||
|
A variable or integer literal. |
SETMAX |
|||
|
A variable or integer literal. |
SETMIN |
|||
|
A variable or integer literal. |
STRIDE |
|||
|
Any valid expression. If the array elements are to be updated by using their current value in the calculation, use the name of the array in place of that value. If the value is just the name of another array variable, then that array is copied. |
TRANSFORM |
|||
|
CONTEXT |
MATH |
|||
|
CLEARVALUE |
Optional |
Value: Yes / No Default Value: No Yes: The value of the math variable will be deleted after the execution of all the Attached Rules at the end of activity processing and will not be visible on the Math tab in the Activity details screen. No: The value of the math variable will be retained after activity processing and will be displayed in the Math tab in the Activity details screen. |
||
|
<Parameters> |
||||
|
<Parameter> |
||||
|
NAME |
A literal value. |
|||
| DATATYPE |
A literal value. Values are limited to:
|
|||
XML Schema
When OPERATION="APPEND"
<MathVariables>
<MathVariable VARIABLENAME="[name]" TYPE="INTEGERARRAY" OPERATION="APPEND" SOURCEARRAY="[math variable]" DATATYPE="INTEGER">[math variable | literal]</MathVariable>
When OPERATION="ARRAYFUNCTION"
<MathVariable VARIABLENAME="[name]" TYPE="INTEGERARRAY" OPERATION="ARRAYFUNCTION" SOURCEARRAY="[array]" DATATYPE="INTEGER">[math variable | literal]</MathVariable>
When OPERATION="COPY"
<MathVariable VARIABLENAME="[name]" TYPE="INTEGERARRAY" OPERATION="COPY" SOURCEARRAY="[math variable]" DATATYPE="INTEGER"/>
When OPERATION="CREATE"
<MathVariable VARIABLENAME="[name]" TYPE="INTEGERARRAY" OPERATION="CREATE" DEFAULT="[literal]" DATATYPE="INTEGER">[math variable | literal]</MathVariable>
When OPERATION="EXPAND"
<MathVariable VARIABLENAME="[name]" TYPE="INTEGERARRAY" OPERATION="EXPAND" SOURCEARRAY="[math variable]" DATATYPE="INTEGER">[literal | literal list]</MathVariable>
When OPERATION="FILLBY-LIST"
<MathVariable VARIABLENAME="[name]" TYPE="INTEGERARRAY" OPERATION="FILLBY-LIST" DATATYPE="INTEGER">[math variable list | literal list]</MathVariable>
When OPERATION="FILLBY-BUCKETLIST"
<MathVariable VARIABLENAME="[name]" TYPE="INTEGERARRAY" OPERATION="FILLBY-BUCKETLIST" DATATYPE="INTEGER">[math variable]</MathVariable>
When OPERATION="FILLBY-SQL"
<MathVariable VARIABLENAME="[name]" TYPE="INTEGERARRAY" OPERATION="FILLBY-SQL" DATATYPE="INTEGER">[sql]</MathVariable>
When OPERATION="FILLBY-STOREDPROCEDURE"
<MathVariable VARIABLENAME="[name]" TYPE="INTEGERARRAY" OPERATION="FILLBY-STOREDPROCEDURE" PROCEDURENAME="[name]" DATATYPE="INTEGER">
<Parameters>
<Parameter NAME="[name]" DATATYPE="[BIGTEXT | DATE | TEXT | INTEGER | DECIMAL]">[math variable | literal | expression]</Parameter>
<Parameter ...>...</Parameter>
</Parameters>
</MathVariable>
When OPERATION="INSERT or OPERATION = "REMOVE"
<MathVariable VARIABLENAME="[name]" TYPE="INTEGERARRAY" OPERATION="[INSERT | REMOVE]" SOURCEARRAY="[math variable]" INDEX="[math variable | literal]" DATATYPE="INTEGER">[math variable | literal]</MathVariable>
When OPERATION="REPLACE"
<MathVariable VARIABLENAME="[name]" TYPE="INTEGERARRAY" OPERATION="REPLACE" SOURCEARRAY="[math variable]" INDEX="[math variable | literal | literal list | math variable list]" DATATYPE="INTEGER">[math variable | literal]</MathVariable>
When OPERATION="SETMIN" or OPERATION="SETMINALL" or OPERATION="SETMAX" or OPERATION="SETMAXALL"
<MathVariable VARIABLENAME="[name]" TYPE="INTEGERARRAY" OPERATION="[SETMAX | SETMIN | STRIDE]" SOURCEARRAY="[math variable]" DATATYPE="INTEGER">[math variable | literal]</MathVariable>
When OPERATION="TRANSFORM"
<MathVariable VARIABLENAME="[name]" TYPE="INTEGERARRAY" OPERATION="TRANSFORM" DATATYPE="INTEGER">[expression | array]</MathVariable>
</MathVariables>
XML Examples
Create and Append
<MathVariable VARIABLENAME="BucketArray" TYPE="INTEGERARRAY" OPERATION="CREATE" DATATYPE="INTEGER"></MathVariable>
<MathVariable VARIABLENAME="BucketArray" TYPE="INTEGERARRAY" OPERATION="FILLBY-BUCKETLIST" CONTEXT="MATH" DATATYPE="INTEGER">FundGUID</MathVariable>
Create and FILLBY-SQL
<MathVariable VARIABLENAME="IntegerCriteriaMV" TYPE="INTEGERARRAY" OPERATION="CREATE" DATATYPE="INTEGER"></MathVariable>
<MathVariable VARIABLENAME="IntegerCriteriaMV" TYPE="INTEGERARRAY" OPERATION="FILLBY-SQL" DATATYPE="INTEGER">SELECT INTEGERCRITERIA FROM RATETABLE WHERE RATEDESCRIPTION = '[RateDescription]' </MathVariable>
Create and FILLBY-LIST
<MathVariable VARIABLENAME="CoverageOptionsArrayMV" TYPE="INTEGERARRAY" OPERATION="CREATE" DATATYPE="INTEGER"></MathVariable>
<MathVariable VARIABLENAME="CoverageOptionsArrayMV" TYPE="INTEGERARRAY" DATATYPE="INTEGER" OPERATION="FILLBY-LIST">01</MathVariable>
Create and FILLBY-STOREDPROCEDURE
<MathVariable VARIABLENAME="Integers" TYPE="INTEGERARRAY" OPERATION="CREATE" DATATYPE="INTEGER"></MathVariable>
<MathVariable VARIABLENAME="Integers" TYPE="INTEGERARRAY" OPERATION="FILLBY-STOREDPROCEDURE" DATATYPE="INTEGER" PROCEDURENAME=" TestRatesProc ">
<Parameters>
<Parameter NAME="AGE" DATATYPE="INTEGER">VarAge</Parameter>
<Parameter NAME="GENDER" DATATYPE="TEXT">01</Parameter>
</Parameters>
</MathVariable>