QuerySort()
Sorts the query based on the column specified and the order criteria given. Modifies the original query object
Usage
QUERY = QuerySort(
query,
column,
type,
direction
)
| Argument | Summary |
|---|---|
| query | query |
| column | column name |
| type | type - ('text', 'textnocase', 'numeric') |
| direction | direction - ('asc' or 'desc') [optional] |
Calling
Supports named-parameter calling allowing you to use the function like:
QuerySort( query=?, column=?, type=?, direction=? );
Supports passing parameters as a structure using ArgumentCollection:
QuerySort( ArgumentCollection={
query : ?,
column : ?,
type : ?,
direction : ?
} );
See Also
Csvread
Csvwrite
Datasourcecreate
Datasourcedelete
Datasourceinfo
Datasourceisvalid
Dbinfo
QueryAddcolumn
QueryAddrow
QueryColumnarray
QueryColumnlist
QueryDeletecolumn
QueryDeleterow
QueryEach
QueryIsempty
QueryNew
QueryOfqueryrun
QueryRenamecolumn
QueryRequestmetrics
QueryRowstruct
QueryRun
QuerySetcell
QuerySort
QueryToarray
Quotedvaluelist
ToHtml
Valuelist
