QueryToList Function

Gets value list from Query.

Syntax 1

QueryToList(queryName, valueColumnName, displayColumnName)

Gets value list from Query.

Arguments

queryName DataElement - The SQL Query to use.

valueColumnName String - Name of the value column.

displayColumnName String - Name of the display column.

Syntax 2

QueryToList(queryName, valueColumnName, displayColumnName, passThruArgs)

Gets value list from Query.

Arguments

queryName DataElement - The SQL Query to use.

valueColumnName String - Name of the value column.

displayColumnName String - Name of the display column.

passThruArgs Expression - One or more passThru expressions.

Remarks

Example:

QueryToList(AQueryValueList, "ID", "Descr"); // returns value-list:{{1, "a"}, {2, "b"}, {3, "c"}}