Features
Smart Filters
Filter query results client-side with a visual filter builder
Smart Filters
Smart Filters let you narrow down query results without rewriting SQL. Filters run client-side on already-fetched data.
Adding a Filter
- Click the filter icon in the results toolbar
- Select a column from the dropdown
- Choose an operator
- Enter a value
- The filter is applied immediately as a chip
Filter Operators
Text Columns
| Operator | Description |
|---|---|
| contains | Substring match |
| equals | Exact match |
| starts with | Prefix match |
| ends with | Suffix match |
| is empty | NULL or empty string |
| is not empty | Has a value |
Numeric Columns
| Operator | Description |
|---|---|
= | Equal to |
!= | Not equal to |
> | Greater than |
>= | Greater than or equal |
< | Less than |
<= | Less than or equal |
| between | Range (two values) |
| is empty | NULL |
Date Columns
| Operator | Description |
|---|---|
| equals | Exact date match |
| before | Earlier than date |
| after | Later than date |
| between | Date range |
| is empty | NULL |
Boolean Columns
| Operator | Description |
|---|---|
| is true | Value is true |
| is false | Value is false |
| is empty | NULL |
Stacking Filters
Add multiple filter chips to narrow results further. All filters are combined with AND logic.
Removing Filters
Click the X on any filter chip to remove it, or click Clear All to remove all filters.
Smart Filters are great for exploring a large result set without re-running queries. For server-side filtering, add a WHERE clause to your SQL instead.