Sorting the History Records - SQL Assistant

Sorting the History Records

There are two ways to sort the history locally: quick sort or full sort. Full Sort allows sorting of data in multiple columns.

To sort history using quick sort

✔ Click the sort icon in any column header to sort the data by that column only.

The data is initially sorted in ascending order. Clicking the sort icon again reverses the sort order.

To sort history using full sort

1 Do one of the following:

On the toolbar, click .

Right-click in the History window, then select Sort.

Select Edit > Sort.

In the Sort dialog box, all columns in the active History window are presented in the Available Columns list.

2 Select the column name in the Available Columns list and click the Add button.

By default, the sort direction for this new sort column is ascending.

Use the up or down icons to change the sort order.

3 To remove a sort column from the list, double-click the column name, or select it and press the Delete key or click the Remove button. You can also remove all columns from the Sort Keys list by pressing the Clear button.

If you want to reset all the columns in the Sort Keys list back to the Available Columns list box, click Clear.

4 After you have selected the columns by which you want to sort and the direction in which you want to sort, click Sort.

Note: Sorting history the Seq (sequence number) column has exactly the same effect as sorting by date and time. However, it is considerably faster.