Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Create multi-column sort orders for stream data.

Note: 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.

...

Insert excerpt
_standard_settings
_standard_settings
nopaneltrue

If the stream property tab has been opened from a stream data grid, the toolbar includesImage Added Refresh the grid using sort order. This does not save the sort order/

Basic Settings

FieldDescription
NameThe name of the sort order.

Sort Order Attributes

A list of the stream attributes used to sort the data.

To add attributes, press

...

Image Added and drag, and drag stream attributes into the list of sort order attributes.

For each sort order attribute, configure the following fields:

FieldDescription
OrderThe order that the sorting will be applied
NameThe name of the stream 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

DescriptionDescription of the sort order attribute.

Access Permissions

Image Removed
This icon is available when this form has been opened from a Stream Data Grid. Pressing the icon causes the grid to be refreshed with data sorted according to the defined order (but without saving the order)
FieldDescription
All Users Can View Sort Order

If checkedticked, this specifies that all users can view this sort order by default (provided they have the basic privilege to view sort orders).

If this field is not checkedticked, then access to the underlying data is controlled by dropping adding user groups onto the "User Groups" grid grid.

Note that the default setting for this field is controlled by the system parameter allowAccessToDataByDefault.

Description
DescriptionDescription of the sort order.

Form Icons

The form provides the standard form icons as well as the following:

.