Queries
From CEW
Contents |
QueryColumnArray()
Provides an array of the columns in a query.
Supported by: 
QueryColumnList()
Provides a list of the columns in a query.
Supported by:
QueryDeleteRow()
Allows you to delete a row in a query.
Supported by: 
QueryGetCell()
The counterpart to QuerySetCell, this function returns the value of a row in a query.
Supported by: 
QuerySlice()
Allows you to slice a query into smaller parts.
Supported by:
QuerySort()
Allows you to sort a query by a column name without needing to do a QoQ.
For example, to sort by lastname descending:
QuerySort(qryName,'lastname','desc')
Supported by:
[edit] Inline Query
Inline queries allow you to create a query in a more convenient fashion, using a combination of inline Struct/Array notation:
Query( firstname:Array('john','jack') , lastname:Array('doe','smith') , age:Array(30,49) )
Supported by:
