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 includesImage Modified Refresh the grid using sort order. This does not save the sort order.

Insert excerpt
_property_tabs _property_tabs name basic-h nopanel true

Basic Settings

Sort Order Attributes

This section has a toolbar with standard buttons and the 

Insert excerpt
_attributes_show _attributes_show nopanel true

 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 

Double-click on an attribute to open the its sort order properties, where you can set:

Save the attribute's sort order properties.

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.