Expression View

The Expression tab shows the same filter as text — often faster once you  know the pattern:

The essentials:

• Field names go in `[square brackets]`, exactly as the column is displayed.

• Text goes in `'single quotes'`. Capitalization never matters — `'pass'` matches `Pass`.

• Join tests with `And`, `Or`, and `Not`; parentheses group, just like the Builder's groups.

• `[Down] In (3, 4)` — the value is in the list. `[Distance] Between (0, 3)` — an inclusive range.

• `[FORMATION] Like 'Shot%'` — a pattern, where `%` matches anything and `_`  matches exactly one character.

Worked examples:

The first is third-and-short (counting 4th down); the second is explosive passes; the third is "no Trips or Bunch, and only plays with motion tagged".

Typos are harmless. When you click away from the box, mistakes show as messages right under it — and the app won't switch you back to Builder until the text parses, so your built filter is never corrupted by a  half-finished edit. The hint under the tab shows the pattern any time you forget: "e.g. [PLAY TYPE] = 'Pass' And [GN/LS] >= 12. Leave blank for no filter."

Blank Means Everything

An empty filter matches all plays — the hints say so wherever a filter can be blank ("Leave blank for no filter"). That makes clearing one easy: delete the expression text, or ✕ every rule in the Builder, then save.

There's a safety net behind this, too: if a saved filter ever breaks — say a column it referenced left the column set — it lets all plays through rather than silently hiding your film. You'll always see everything before you see nothing.