PyCharm
 
Get PyCharm

Filter data

Last modified: 29 August 2024

While the Services tool window displays output of your queries, the data editor displays data of a database object as is.

The following topic shows how you can filter data in the data editor. For more information about working with query results in the Services tool window, refer to Query results.

In the data editor, you can filter data by using the following approaches:

  • You can use the local filter to filter rows by values in columns.

  • 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 Ctrl0F and running a search on the table.

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

For more information about filtering tables within a schema in Database tool window, see Speed search in tool windows.