Sort Order
This page is for data modellers who need to sort attributes.
Overview
You can create multi-column sort orders for data in tables and views, from their Sort Orders property section.
Sorting large amounts of data can take some time. To ensure that data is returned as quickly as possible, use filters to ensure that only the data you need is sorted. If there are particular sort orders which need to be applied across large sets of data, please contact PhixFlow Support for help with tuning your PhixFlow instance.
If the table property tab has been opened from a data grid, the toolbar includes Refresh the grid using sort order. This does not save the sort order.
Basic Settings
Field | Description |
|---|---|
Name | The name of the sort order. |
Sort Order Attributes
This section has a toolbar with standard buttons and the
The grid lists the attributes used to sort the data.
To add attributes, click
Double-click on an attribute to open the its sort order properties, where you can set:
Field | Description |
|---|---|
Properties Tab | |
Order | The order that the sorting will be applied |
Name | The name of the attribute - in the sort order attribute editor, this is read-only. |
Direction | One of: (A-Z) - ascending, e.g. A to Z, 1 to 9, earliest to latest date (Z-A) - descending, e.g. Z to A, 9 to 1, latest to earliest date |
Description | Description of the sort order attribute. |
Audit Tab | |
Audit Summary | See the Common Properties page, Audit Summary section. |
Save the attribute's sort order properties.