getElement

Owned by Former user (Deleted)
Last updated: Sept 23, 2021 by Anthony George



Function: getElement()

Returns the item at a specified index position within an Array or Recordset.

Syntax

  1. getElement(set, index)
  2. getElement(set, index, default_value)
  3. set[index]
  4. set.index
ArgumentTypeDescription
setArray or Recordset

The array or recordset to get the result from.

indexInteger

The position of the item in the array to be returned.

If index is not a valid entry, the function returns:

  • either the default_value
  • or _NULL, when no default_value is specified.

An invalid index is outside the array or recordset. Index positions start at 1, so 0 is an invalid index. 

default_valueany type

Optionally, a default value to return instead of _NULL if the index is not valid.

If you use getElement on a single value, PhixFlow treats the value 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.


[].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".

See Also