Sorting Tab - WorkView - Foundation 24.1 - Foundation 24.1 - Ready - OnBase - Premier - external

Sorting Tab - WorkView - Foundation 24.1 - Foundation 24.1 - Ready - OnBase - Premier - external - Premier

WorkView

Platform

OnBase

Product

WorkView

Release

Foundation 24.1

License

Premier

The Sorting tab allows administrators to specify what attribute(s) are used for sorting, and if objects are sorted in ascending or descending order according to the selected attribute(s), when filter results display.

The following is an example of how sorting functions. Here is the data that will be sorted for our example:

FirstName	LastName	YearOfBirth
Thomas	Alva Edison	1847
Benjamin	Franklin	1706
Thomas	More	1478
Thomas	Jefferson	1826

If you sort by first column (descending), then by second column (descending), and lastly by the third column (ascending), the data will be sorted as follows:

FirstName	LastName	YearOfBirth
Thomas	More	1478
Thomas	Jefferson	1826
Thomas	Alva Edison	1847
Benjamin	Franklin	1706

To specify the default sorting order:

Select the Sorting tab.
On the Sorting tab, click Add. The Sort Column Configuration dialog box is displayed.
Select the attribute you want to use by clicking the ellipsis button next to the Attribute field and select the attribute you want to use for sorting. You can also manually enter the path to the attribute if you already know the path.

Note:
Text, Formatted Text, and Alphanumeric (greater than 256 characters) attributes are not available for selection. In addition, relationship attributes that are related to an external class that uses an ODBC connection or is Unity Script filled class cannot be used.
If you would like to sort in descending order, select the Sort Descending check box.
Click OK.

Note:
Only one instance of each attribute can be in a filter Sorting tab.
Repeat steps 2 through 5 for each attribute you want to sort.

Note:
The order of the attributes sorted can be edited by selecting attributes and clicking Move up or Move Down.

Note:
Only one sort can be applied to a column in a filter. If you are using scripting to sort, ensure that you do not sort a column more than once in the Sorting tab and your script.