CLion 2021.1 Help


You can filter data in a table by using the following approaches.

  • Click the column name to filter the column data. 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.

    stacked sorting
  • You can specify filtering conditions manually or use quick filtering options. Quick options are filtering conditions for the current column name. The conditions depend on the value in the current cell.

  • You can filter rows by pressing Ctrl+F and running a search on the table.

  • You can use the Row Filter and filter data in a table by writing a query in the Filter Criteria field.

Use quick filtering options

Quick filtering options work only in the editor, not in the Services tool window.

  1. Right-click a cell and navigate to Filter by.

  2. Select an option that you want to apply.

    Using quick filters
  1. Press Ctrl+F and select Filter Rows.

  2. Start typing your search query (for example, John ).

    Quickly find data inside a table without writing a statement

Filter table data with a query

  1. In the WHERE and ORDER BY fields, type your query. The query syntax is the same as in WHERE and ORDER BY clauses but without the keyword.

    You can use SQL wildcards within the LIKE expressions. For example, the percent sign % for zero or more characters and underscore _ for a single character.

  2. Press Enter.

    To reset the filter, click the clear icon (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 WHERE or ORDER BY keywords.

    WHERE and ORDER BY fields for sorting
Last modified: 08 March 2021