Sorting Dictionary Elements

Sorting enables the user to reorder dictionary elements.

Dictionary elements can be:

Sorted in Ascending or Descending Order. To do this:

In the web application click the Sorting button in the column header and select the required sorting method in the drop-down list:

Ascending. Sort ascending. In case of text data, sort from A to Z.
Descending. It sets descending sorting. In case of text data, sort from Z to A.
Reset. It disables sorting. The item is available only when sorting is used.

After ascending or descending sorting is set up, the icon of the Sorting button changes for the icons of the selected sorting method, and the sorting method becomes disabled in the button's drop-down menu.

In the desktop application select the Sorting > Ascending/Descending item in the dictionary element's context menu. Elements are sorted in accordance with ascending or descending value of the attribute selected in the list of attributes.

NOTE. If on sorting in ascending order no attribute has been selected, the first attribute in the attributes' list is automatically selected when this option is enabled.

In the desktop application click the column header. The column header displays the arrow indicating sorting order:

On the first click the column data is sorted in the alphabetic order, that is, ascending order. On the next clicks on the column header sorting order is changed.

Sorting by columns. To do this, in the desktop application click the Actions button and select the Sorting item. The same-name dialog box opens. Dictionary elements are sorted by columns similarly to sorting of table columns. It is available only on opening a dictionary for view.
Sorting by the list of dimension attributes. To do this, in the desktop application select the Sorting > By Attribute item in the dictionary element's context menu. The list includes all dictionary attributes. Select the checkbox next to the attribute, which value will be used for sorting. The Ascending option is selected by default if no sorting has been set before attribute selection. It is available only on opening a dictionary for view.

NOTE. If an attribute should not be displayed in the Sorting submenu, set it as hidden in the dictionary. To do this, select the Hidden checkbox in the Dictionary Attribute Properties dialog box.

To reset sorting settings in the desktop application, select the Sorting > Reset item in the dictionary element's context menu. The dictionary elements are sorted in accordance with the method configured at the dictionary creation. It is available only on opening a dictionary for view.