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.

Property Pane Toolbar

For information about the toolbar options, see the Common Properties page, Toolbars and Controls section.

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.

Properties Tab

Parent Details

If this item is within or belongs to another, its parent name is shown here. See the Parent Details section on the Common Properties page for more details.

Basic Settings

Field	Description
Name	The name of the sort order.

Sort Order Attributes

This section has the Show Attributes button. For new sort orders, first add a name and save the properties to display the toolbar.

The grid lists the attributes used to sort the data.

To add attributes, click Show Attributes to display a list of attributes. Drag an attribute from the list into Sort Order Attributes.

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 Audit Summary section on Common Properties.

From PhixFlow version 11.3.2+, when applying a Sort Order to a View which contains a count() attribute, the count() performs aggregation on the records in the View. In this case, if an attribute that is not in the View is used within its Sort Order, it will be ignored.

Description

We recommend that you always enter a description to explain the purpose of this item.

Security Tab

Access Permissions

See the Common Properties page, Access Permissions section.

By default, the permissions to access table data is set in System Configuration → Allow access to data by default. You can add specific user groups to restrict access to the view order; see Common Properties. → Access Permissions.

Audit Tab

Audit Summary

See the Common Properties page, Audit Summary section.

Sections on this page

Learn More

Overview

Property Pane Toolbar

Properties Tab

Parent Details

Basic Settings

Sort Order Attributes

Description

Security Tab

Access Permissions

Audit Tab

Audit Summary

Search

Browser not supported