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.

<%= heading %>