AppCode 2021.2 Help

Sort

To 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 ⌃⌥S and navigate to Database | Data Views. Change the value for the Add columns to sorting option.

stacked sorting

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

  1. In the ORDER BY field, type your query. The query syntax is the same as in the ORDER BY clause but without the keyword.

  2. Press .

    To reset the filter, click the clear icon (The clear icon), or delete the contents of the row filter field and press .

    To open the filter history, click the arrow icon near the ORDER BY keyword.

    WHERE and ORDER BY fields for sorting
Last modified: 27 August 2021