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
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

Related

• QueryAddColumn

• QueryAddRow

• QueryAppend

• QueryClear

• QueryColumnArray

• QueryColumnCount

• QueryColumnData

• QueryColumnExists

• QueryCurrentRow

• QueryDeleteColumn

• QueryDeleteRow

• QueryEach

• QueryEvery

• QueryFilter

• QueryGetCell

• QueryGetResult

• QueryInsertAt

• QueryKeyExists

• QueryMap

• QueryPrepend

• QueryRecordCount

• QueryReduce

• QueryReverse

• QueryRowData

• QueryRowSwap

• QuerySetCell

• QuerySetRow

• QuerySlice

• QuerySome

• QuerySort