Sort Database

For the contents of the cells of the database’s table there is a capability of simultaneous sorting by several columns. Such sorting can be used in order to group the data with equal values in one single column, and then carry out sorting of another column in these groups with equal values.

Use the following command in order to sort database by several columns:

After calling this option the Sorting dialog window will appear in which it will be possible to indicate the sorting options for several columns.

For example, suppose there is a database of parameters of flange couplings.

It is required to group the data that has equal values in the column isp, then execute sorting of the column d in these groups with equal values.

To do so, on the main toolbar invoke the Sorting option. In the window that appears in the fields of the columns 1 and 2 specify conditions for sorting the values of parameters isp and d, respectively.

After pressing ОК, the data of the table will be grouped according to the specified conditions.

In order to sort database by a single column, use command of column's header contextual menu: