Function: getElement()
Returns the item at a specified index position within an Array or Recordset.
Syntax
getElement(set, index)getElement(set, index, default_value)set[index]set.index
| Argument | Type | Description |
|---|---|---|
| set | Array or Recordset | The array or recordset to get the result from. |
| index | Integer | The position of the item in the array to be returned. If index is not a valid entry, the function returns:
An invalid index is outside the array or recordset. Index positions start at 1, so 0 is an invalid index. |
| default_value | any type | Optionally, a default value to return instead of _NULL if the index is not valid. |
If there is only one item in the set, getElement treats it as the first item in an array.
Examples
getElement(["Red", "Green", "Blue"], 2)
Returns the 2nd element, "Green".
getElement(["Red"], 1)
Returns the element, "Red".
["Red", "Green", "Blue"].3
Returns the 3rd element, "Blue".
getElement(["Red", "Green", "Blue"], 5, "NoData")
Returns the default_value "NoData" as there is no element at position 5.
["Red", "Green", "Blue"].8
Returns _NULL, as there is:
- no element at position 8
- no default_value set.
getElement(["Red"], 1)
Returns Red, as if it is the first element in an array
[].1
Returns _NULL as there are no elements.
in.CustomerNames
returns a list of customer names that exist on the records on the in pipe. Please note that only recordsets can be indexed in this way, and lists must be accessed using numerical indices, as above.
in.$attributeName
will return the same as in.CustomerNames, if $attributeName is set to the string value $attributeName = "CustomerNames".