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