Filtering
Filter Data Grid rows in tpaw using column filters with operators for text, numbers, dates, NULL checks, and JSONB paths.
The Data Grid filter system lets you narrow the visible rows using one or more column conditions. Filters are applied server-side via SQL WHERE clauses, so they work efficiently even on very large tables.
Opening the filter panel
Click the Filter button in the Data Grid toolbar to open the filter panel below the column headers. Each active filter appears as a condition row.
Adding a filter
- Click + Add Filter in the filter panel
- Select the column to filter on from the dropdown
- Choose an operator (the list adapts to the column's data type)
- Enter the value (some operators like "is empty" don't need a value)
- The grid updates immediately as you type
Filter operators
Standard operators (all column types)
| Operator | SQL equivalent | Notes |
|---|---|---|
| is | = value | Exact match |
| is not | != value | Excludes exact match |
| greater than | > value | Numeric/date comparison |
| less than | < value | Numeric/date comparison |
| greater or equal | >= value | |
| less or equal | <= value | |
| contains | LIKE '%value%' | Case-sensitive substring |
| contains (ignore case) | ILIKE '%value%' | Case-insensitive substring |
| is empty | IS NULL | No value needed |
| is not empty | IS NOT NULL | No value needed |
JSONB operators (json/jsonb columns only)
| Operator | Description | Example value |
|---|---|---|
| has key | JSON object has a key at path | user.name |
| contains | JSON value contains object | {"status": "active"} |
| path equals | Path matches value | tags.0=featured |
| jsonpath | PostgreSQL jsonpath expression | $.list[*] ? (@.id == 1) |
Note: GIN index warning — if your JSONB column doesn't have a GIN index, tpaw shows a warning that the filter may be slow on large tables.
Multiple filters
Add multiple filters to combine conditions. By default, conditions are combined with AND (all must match). Use the logic toggle to switch between AND / OR for the entire filter set.
Removing filters
Click the × on any filter row to remove it. Click Clear All in the filter toolbar to remove all active filters at once.
Sorting alongside filters
You can use filters and sort simultaneously. The sort order applies to the filtered result set.
Filter indicator
When filters are active, the Filter button in the toolbar shows a badge indicating the number of active conditions. This reminds you that the grid is showing a filtered subset of the table.
Filters and pagination
Filters apply to the full table — pagination reflects the total row count of the filtered result, not the underlying table size.