QueryToList Function

  • Updated

Gets value list from Query.

Syntax 1

 

Gets value list from Query.

 

QueryToList(queryName, valueColumnName, displayColumnName)

 

 

Arguments:

 

 

 

queryName

DataElement - The SQL Query to use.

 

 

valueColumnName

String - Name of the value column.

 

 

displayColumnName

String - Name of the display column.

Syntax 2

 

Gets value list from Query.

 

QueryToList(queryName, valueColumnName, displayColumnName, passThruArgs)

 

 

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"}}.

Was this article helpful?

0 out of 0 found this helpful

Comments

0 comments

Article is closed for comments.