Filter rows by column#

A filter narrows the grid to the rows you care about. It runs in the database, so it works across the whole table, not only the rows currently loaded on screen.

Each column header carries a filter icon. Select it to open that column's filter. The icon stays filled while a filter is active, so you can see at a glance which columns narrow the view.

Set a column filter#

The filter you get suits the column.

• Text: matches rows that equal a value, contain it, or start or end with it. It also matches rows that are empty or not empty.
• Numbers: sets a range with a lower and an upper bound.
• Repeated values: lists the values in the column, and you tick the ones to keep.

Filters combine across columns: add one to two different columns and the grid shows only rows that satisfy both. The status bar shows how many filters are active.

Remove a filter#

Empty a column's filter to remove it, and the grid widens back out. When you switch to a different table, Database Client clears all filters, so each table starts unfiltered.

Filter then edit the rows#

Filters and edits work together. You can filter a large table down to the handful of rows you need, edit them in place, and clear the filter when you are done. The filter runs in the database rather than on the loaded rows, so the rows it finds are always current.