TSTool / Command / SortTable
Overview
The SortTable
command sorts rows in a table by sorting the values in one or more columns.
The column(s) to be sorted can be of type string, integer, double, float, or date/time.
Strings are sorted by ignoring case.
Command Editor
The following dialog is used to edit the command and illustrates the command syntax.
SortTable
Command Editor (see also the full-size image)
Command Syntax
The command syntax is as follows:
SortTable(Parameter="Value",...)
Command Parameters
Parameter | Description | Default |
---|---|---|
TableID |
The identifier for the table. Can be specified using processor ${Property} . |
None – must be specified. |
SortColumns |
The names of columns to sort, separated by commas. One or more columns can be sorted. | None – must be specified. |
SortOrder |
The sort order for columns specified by SortColumns , using the syntax:SortColumn1:Ascending,SortColumn2:Descending As indicated in the above example, the sort order must be specified as one of the following:
|
Ascending |
Examples
See the automated tests.
Troubleshooting
See Also
NewTable
command