Lookup Function List
Return values from data sets when filtering criteria is matched.
| Lookup Function | Description |
|---|---|
| CollectionLookup | The CollectionLooup function returns the value of a field or expression for the first collection member that satisfies a given filter expression. |
| GetFieldValueList | Gets specified value list by field name. |
| GetValueList | Gets specified value list by DataElement name. |
| IsInValueList | Returns true if the given value is contained in the specified value list, otherwise returns false. |
| JsonLookup | The JsonLookup function returns the JSON of the first property or array that matches a given search path. Does not support retrieving an array of primitive values. |
| Lookup | Returns the value from a table for the first row that satisfies the filter. |
| QueryToList | Gets value list from Query. |
| TableLookup | Returns the value from a table for the first row that satisfies the field matching criteria. |
| ToValueList | Constructs value list inline from args. |
| ValueListLookup | Looks up a display name by value from a value list. If the value is not in the value list, null is returned unless a default value is specified. |
| XmlLookup | The XmlLookup function returns the value referenced by an XPath from an XML document or string. |