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".
QueryNew(columnList=[any], columnTypeList=[string], rowData=[any])
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}] |
- 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