QueryNew

Return new query based on the provided column list, column types, and/or row data.

Available column types are:

bigint
binary
bit
date
decimal
double
integer
null
object
other
time
timestamp
varchar

If columnTypeList is empty, all columns will be of type "object".

Method Signature

QueryNew(columnList=[any], columnTypeList=[string], rowData=[any])

Arguments

Argument Type Required Description Default

Argument	Type	Required	Description
`columnList`	`any`	`true`	The column list to be used in the query, Ex: "name, age, dob". It can also be an array of structs that will be used as the row data.
`columnTypeList`	`string`	`false`	Comma-delimited list specifying column data types. If empty, all columns will be of type "object". Ex: "varchar, integer, date"
`rowData`	`any`	`false`	Data to populate the query. Can be a struct (with keys matching column names), an array of structs, or an array of arrays (in same order as columnList). Ex: [{name: "John", age: 30}, {name: "Jane", age: 25}]

columnList

any

true

The column list to be used in the query, Ex: "name, age, dob". It can also be an array of structs that will be used as the row data.

columnTypeList

string

false

Comma-delimited list specifying column data types. If empty, all columns will be of type "object". Ex: "varchar, integer, date"

rowData

any

false

Data to populate the query. Can be a struct (with keys matching column names), an array of structs, or an array of arrays (in same order as columnList). Ex: [{name: "John", age: 30}, {name: "Jane", age: 25}]

Examples

PreviousQueryMap NextQueryPrepend

Last updated 1 month ago

Method Signature

Arguments

Examples

Related