Configure Sorting
Data sorting in the Table visualizer is performed according to the rules described in the Sorting node.
Configuration Window
The fields used for sorting and the columns with the visibility disabled in the Table are displayed in the left list.
It is possible to filter the list of fields by specifying the field caption in the filter area.
To configure sorting, it is required to move the necessary fields to Sort fields list. It can be done as follows:
- by drag-and-drop method;
- by double click on the field with the left mouse button;
- by calling the drop-down menu using the right mouse button and pressing
Add button; - by pressing
Add button.
Parameters of sorting configuration are set in two adjacent columns:
- Order: the sorting type switch is displayed in the cells of this field. It can take Ascending
and Descending 
order. - Case-sensitive: in the cells of this field on condition that the sorted values
String or 
Variant types, the checkbox is displayed. When the checkbox is selected, the case-sensitive field is sorted.
It is required to perform the following actions to exclude from the list of sorted fields:
- to drag the record from Sort fields list to Available fields;
- to press
required field in column 
button; - to call the drop-down menu by pressing the right mouse button and pressing Delete button.
To clear the whole list, it is required to press icon near the column with the same name by calling the drop-down menu, select Delete all....
To change the sorting order, the navigational buttons are located above the table of sorted fields:
Move up enables to move the selected field up in the order list.
Move down enables to move the selected field down in the order list.
It is also possible to move the field by selecting the required field and calling the drop-down menu. Then press Move up or Move down depending on the required action.
When all settings are selected, it is required to press Sort to enable sorting in the table.
Note: Comparison and sorting of characters are performed according to the local settings of the user that started the Megaladata server.