Sorting Data Tables
You can sort many Web Workspace data tables to display rows in a particular order. Some of the Web Workspace tools also allow you to create your own user-defined sorts. These options, if available, will be found in the tool's Sort menu or from an context menu when you right-click a column heading.
You can apply ascending or descending sorts to a single column in a table (where configured) by clicking once on the column header; clicking a second time on the column header will sort the rows in the opposite order. An arrow appears next to the column label identifying if the sort is ascending or descending.
Sort topics include:
Using the Sort Dialog Box
Some Web Workspace tools allow you to create, modify, apply, and save user-defined sorts. Sorts are saved for each application, user, and user type. Thus, if a user logs in with multiple user types, each type will have their own set of sorts.
If a table supports user-defined sorts, select Sort Dialog… from the Sort menu or click the Sort button on the toolbar to display the Sort Dialog. You can also right-click the table header and then select Sort... from the context menu.
The Sort Dialog displays the following items:
The Current Sort drop-down list presents a list of saved sorts for modification. When you select a sort from the list, the sort criteria are displayed.
The table within the dialog box allows you to specify the order in which the sort criteria is applied, which column in the application is to be used in the sort criteria, and in which direction the sort is to be applied (ascending, descending).
The OK button applies the current sort to the table of data and exits the Sort dialog box.
The Save... button opens a dialog box for naming and saving the current sort. Saving automatically applies the sort. You can retrieve sorts through the option menu on the Sort Dialog and the Sort menu in the window.
The Delete button opens a dialog box asking you to confirm the deletion of the selected sort. Once it is deleted, you can no longer retrieve the sort.
The Show button applies the current sort settings to the table of data, but does not exit the Sort Dialog.
The Help... button display help for using the Sort Dialog.
The Exit button closes the Sort Dialog.
Creating a User-Defined Sort
To create a user-defined sort, complete these steps:
1. Open the Sort Dialog by selecting Sort Dialog… from the Sort menu or by right-clicking the table header and selecting Sort... from the context menu.
2. In the row for Order 1, click on the drop-down list under Column and select the first column you wish to sort by, and then click on the drop-down list under Direction and select which order you wish to sort the column by.
3. Repeat the previous step for any other columns you additionally want to sort by.
4. Click the Save… button. The Store the Sort? dialog box appears, prompting you to name the sort.
5. Click the Yes button. The Store the Sort? dialog box appears, and the name you provided now appears in the option menu of saved sorts.
6. Click the OK button. The Sort Dialog closes, and the sort is saved to the database.
Editing and Deleting Saved Sorts
You can use the option menu in the Sort Dialog to select a saved sort for modification. You can also delete a saved sort by selecting it from this menu and clicking on the Delete button.
Quick Sorting
You can sort the contents of a list by clicking on a column header. An icon indicates that the column is being sorted; ascending () or descending () order.