TSTool / Command / SortTable

Overview
Command Editor
Command Syntax
Examples
Troubleshooting
See Also

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 command is available in the following TSTool menu:

Commands(Table) / Manipulate Table Values

The following dialog is used to edit the command and illustrates the command syntax.

SortTable Command Editor (see 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` `Descending`	`Ascending`

Examples

See the automated tests.

Troubleshooting

See the main TSTool Troubleshooting documentation.