Filter

The advanced filter helps you quickly filter out data from a table. It saves you time writing long & complex queries.

TablePlus generates the SELECT queries with the WHERE conditions defined by the filters to execute and return the results.

Row filters

Open the data filter by clicking on the Filters button at the bottom, or use shortcut key ⌘ + F.

  • To apply a single filter, click on the Apply button on the right of that filter, or you can select that filter and press Return key.

  • To duplicate a filter, click on the + button on the right of that filter, or you can select it and use shortcut key ⌘ + I.

  • To remove a filter, click on the - button on the right of that filter, or you can select it and use shortcut keys ⌘ + ⇧ + I.

  • To apply multiple filters, tick the checkbox on the left to select, and click Apply all or use shortcut key ⌘ + Return to apply the selected filters.

  • To reload the table content without filtering, click the Unset button

  • To show the generated SQL query, select the filters and click on the SQL button.

  • To exit the filters, press ESC key, or click on the Filters button at the bottom of the table.

You can see the Apply button of each filter to know the status of the current data table. If the button is Apply, it's not filtered. If the button is Applied, the table is being filtered by it.

To open a quick filter by a column, right click on the column title and choose Filter with column

A quick filter by value can also be opened by right clicking on a data cell and choose Quick filter, or clicking on foreign key referencing arrow in a data cell.

Customize default filter

There are some setting options for the row filters that you can find by clicking on the config/setting button right below the filters:

  • Change default filter column to:

    • Raw SQL

    • Primary key (if exist)

    • Any column

  • Change default filter operator to:

    • =

    • Contains

  • Change the default filter state to:

    • Restore the last filter state

    • Always show

    • Always hide

Column filter

The column filter is used to show only some selected columns from the current table.

To use the column filter:

  • Click on the Column button at the bottom or use the shortcut key ⌘ + Option + F.

  • Select the columns you want to see, and hit Apply.

To go back to the full table view, open the column filter, click on Clear button, then Apply.