Filter


Three entry points: the column filter row, the FILTERS panel, and Raw SQL. Changes take effect immediately with no need to click Apply, and conditions across multiple columns are joined with and.

▶ Tutorial

Filtering demo: column filter row, value list, FILTERS panel, and Raw SQL

Filter row

Every column has a filter box below its header, and each accepts two forms. The lightning icon to the left of the box toggles filtering for that column: click once to disable it, and the icon turns gray with the input no longer editable; click again to restore it.

Column filter row

Column filter row: IN (...) typed in the name column for multi-value matching; the lightning icon at the left of each column toggles that column’s filter

Normal mode: type a value or a SQL fragment directly.

FormExampleDescription
ContainsfooEquivalent to like '%foo%'; not an exact match
Exact match= fooEquivalent to = 'foo'; the value must match exactly
Prefix / suffix%foo, foo%Ends with / starts with foo
Comparison=1, >1, <=10, !=1Numeric or string comparison
Null checkis null, is not nullTest for null
Setin (1,2,3), not in ('a','b')Multi-value match
Patternlike '%foo%', not like '%foo%'Explicit LIKE
Rangebetween 10 and 20Inclusive range

Raw SQL mode: a leading @ treats the input as a SQL expression, and ? stands for the current column.

FormExample
Apply a function to the column@substr(?,2) = 'foo'
Column-to-column expression@(? > 100 OR ? - price > 10)

Two escape forms:

  • ?? stands for a literal question mark (not treated as the column placeholder).
  • @@ stands for a literal @: @@foo is not parsed as Raw SQL, which lets you filter data whose content itself starts with @.

Value list: click the dropdown to the right of the filter box to list the distinct values already present in that column.

  • Each entry shows its occurrence count, with NULL and EMPTY labeled separately.
  • Selecting several items filters with in (...).
  • The Filter: input at the top narrows the value list further, and CNT n at the bottom shows the current count.

Quick actions: three buttons at the bottom of the value list.

ButtonAction
IncludeKeep only the selected values
ExcludeExclude the selected values
BetweenFilter by range

FILTERS panel

The FILTERS tab at the bottom expands the conditions into a table, which suits cases with many conditions that need fine control:

FILTERS panel

FILTERS panel: one condition per row, with focus, reorder, and delete

ColumnDescription
FocusWhen selected, the grid scrolls to and locates the column for that condition
Column NameChoose the target column
Filter ValueCondition value, with the same syntax as the column filter row
OperateShows the current operator
CommentA note
DataTypeType and constraint information for the column

Each row can be added, deleted, moved up, or moved down on the right; condition order affects the generated SQL.

All Columns: set Column Name to All Columns and enter a value in Filter Value to match across every column (placeholder Search across all columns...). Useful when you are not sure which column holds the value and do not want to try them one by one.

Cross-column filtering

Column Name set to All Columns: entering American matches across all columns

Raw SQL

Below the FILTERS panel, Raw SQL is collapsed and shows the statement that will actually run:

Raw SQL

Raw SQL: shows the final statement, where {FilterSql} is the condition placeholder

{FilterSql} is where the panel conditions go. You can edit this SQL directly and click Run current on the right to run it; the edited conditions are merged with the column filter row conditions into the same WHERE.

Sorting

Click a column header to sort, and click again to toggle ascending / descending; hold Shift and click multiple columns to combine sorts, with the header showing a number for priority.

Clearing filters

  • Single column: clear the content of its filter box.
  • All columns: delete every condition in the FILTERS panel, or clear the WHERE part of the Raw SQL.

Quick filter

Select one or more cells in the data area, right-click → Quick Filter, and the menu generates a set of conditions from the selected values; click one to apply it:

Menu itemGenerated condition
Column name = value= 'value'
Column name <> / > / >= / < / <=The corresponding comparison
Column name LIKE '%value%' / NOT LIKE '%value%'Pattern match
Column name IN (…) / NOT IN (…)A list built from the deduplicated selected values
Column name IS NULL / IS NOT NULLNull check
Clear All FilterClears filters on all columns
  • When multiple columns are selected, each column generates its own condition.
  • After applying, it is equivalent to typing in the column filter row: the condition appears in the FILTERS panel and can be edited further.
  • Good for filtering on a value you can see, without typing the syntax by hand.

Filter query results

After running complex SQL in Query (CTEs, window functions, aggregate reports), the grid in the RESULT-n result tab supports filtering the same way as table data.

Query result → column filter → value list → quick filter

Filtering query results

Entering =14 in the customer_cnt column of RESULT-1

  • The column filter row, value list, and FILTERS panel all work; Include / Exclude / Between in the value list behave the same.
  • These results are usually read-only: the right side of the status bar shows Read Only, so you can filter, sort, and search, but not edit values or add or delete rows.
  • Useful for running a report first and then drilling down by column within the result set; filtering only affects the current result and does not rewrite the original SQL.

Value list and quick actions

The value list shows occurrence counts, with Include / Exclude / Between at the bottom