To sort rows in a table, select the entire table (or specific rows) and use the
Sort action from the main toolbar
or the contextual menu. This opens the Sort dialog box.
Figure: The "Sort" Dialog Box
This dialog box sets the range that is sorted and the sorting criteria. The range is automatically selected depending on whether you sort an entire table or only a selection of its rows.
Note: When you invoke the sorting operation over an entire table, the Selected
rows option is disabled.
The Criteria section specifies the
sorting criteria (a maximum of three sorting criteria are available), defined by the following:
- A name, which is collected from the column heading.
- The type of the information that is sorted. You can choose between
the following:
- Text - Alphanumeric characters.
- Numeric - Regular integer or floating point numbers are accepted.
- Date - Default date and time formats from the local OS are accepted (such as short, medium, long, full, xs:date, and xs:dateTime).
- The sorting direction (either ascending or descending).
The sort criteria is automatically set to the column where the cursor is located at the time when the sorting operation is invoked.