Reference
Filter reference
Seven controls, the operators behind each, regex inside a single filter, and the one rule that decides what a whole filter set means.
The rule
And, or and not — and why position does not matter
Each filter carries its own connector. The whole set resolves by one rule, not by the order you happen to have dragged the cards into.
(or or or) AND NOT(n) AND (and) AND (search)
A result must match every filter marked and, at least one filter marked or, and none of the filters marked not. The search box always narrows the whole expression, so it can never be widened by someone else’s or.
Reordering your filters cannot change your results. That is deliberate. The obvious alternative is to let and bind tighter than or, the way it does in arithmetic, and it quietly breaks: it cannot express “any of these three, and also that one”, because the extra condition can only attach to a single alternative.
What that costs if you get it wrong
Measured on the live database: “gold in any of seven text fields, and country is India” returns 911 shops. Under the tighter-binding alternative the same filter set returns 38,969 — because the country condition silently stops applying to six of the seven fields. You would export forty times the rows you asked for and never see an error.
Controls
Seven controls, five sets of operators
Link fields filter as text, and yes/no fields filter as dropdowns — so there are more controls on screen than there are operator sets to learn.
| Control | Filters as | Fields |
|---|---|---|
| Number | numeric | 34 |
| Text | text | 17 |
| Link | text | 15 |
| Dropdown | dropdown | 13 |
| Tags | tags | 10 |
| Yes / No | dropdown | 8 |
| Date | date | 1 |
Operators
What each kind of field can do
Text
Text and Link fields- contains
- is empty
- ends with
- is exactly
- is not empty
- matches a pattern (regex)
- starts with
Number
Numeric fields- is between
- is empty
- equals
- is at least
- is at most
- does not equal
- is not empty
Tags
Multi-value fields- has all of
- has any of
- has none of
Dropdown and yes/no fields select from their available values. Date fields take a range.
Patterns
Regex, including several patterns inside one filter
A text filter is not limited to one pattern. Each term carries its own and, or or not, so a single field can express a rule that would otherwise need several filters.
A term preceded by not excludes rather than requires, so you can write “matches this, or that, but not the other” against a single field.
Patterns run on a linear-time engine, which is the reason lookahead is not supported. It is a deliberate trade: a pattern can never take exponential time and hang your search, so there is no query you can write that stalls the grid.
See what you can filter on
All 98 fields, what each one means, and which control it uses.