WebStorm 2020.2 Help

Filter

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

  • 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

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

  2. Select an option that you want to apply.

  1. Press Ctrl+F and select Filter Rows.

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

Filter table data with a query

  1. If the Filter Criteria field is not available, click the settings icon (the settings icon ) and select Row Filter.

  2. In the Filter Criteria field, type your query. The query syntax is the same as in the WHERE clause but without the WHERE keyword. For example, first_name LIKE 'JOH%' AND last_name LIKE 'CA%'.

    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.

  3. 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, press Alt+Down.

Last modified: 29 October 2020