Sort
Last modified: 10 August 2022To sort the column data, click the column name. The column sorting is not stacked by default. It means that if you click a column name to sort data by, the sorting based on other columns will be cleared. If you prefer to use the stacked sorting, click a column name while pressing Alt.
To change the default option for stacked sorting, open settings by pressing Ctrl+Alt+S and navigate to Tools | Database | Data Editor and Viewer. Change the value for the Add columns to sorting option.

Also, you can use the ORDER BY filter and sort data in a table by writing a query in the ORDER BY field.
Filter table data with a query
note
If the filter is not available, click the settings icon (
) and select Show Filter. Alternatively, press Ctrl+Alt+Shift+F.
note
Available only in the data editor, not in the Services tool window.
In the ORDER BY field, type your query. The query syntax is the same as in the
ORDER BY
clause but without the keyword.Press Enter.
To reset the filter, click the clear icon (
), or delete the contents of the row filter field and press Enter.
To open the filter history, click the arrow icon near the ORDER BY keyword.
Thanks for your feedback!