Search Grammar

Dieser Inhalt ist noch nicht in deiner Sprache verfügbar.

Type like you think. The search understands.

The Explorer search bar accepts a progressive grammar — beginners type words, experts type expressions, both get results. The v2 grammar is a backward-compatible superset of the old syntax: everything you could type before still works.

Six Levels of Syntax

Level 1 — Just type

The simplest case: type any words. Multiple words become AND filters. Double-quote an exact phrase.

paracetamol                  → contains "paracetamol" in any column
hip replacement              → contains "hip" AND "replacement"
"Scalpel Blade #10"          → exact phrase match

Level 2 — Operators

Comparisons on numeric and date columns. Ranges with ...

>1000                        → any numeric column > 1000
<50                          → any numeric column < 50
100..500                     → any numeric column between 100 and 500
2025-01..2025-06             → any date column in this range
>=high                       → ordinal: low < medium < high

Ranges also work for dates at month granularity (2025-01..2025-06), day granularity (2025-04-01..2025-04-30), or mixed.

Level 3 — Field-specific filters

Scope the filter to a single column with !field:value. The ! prefix marks this as a field filter, not a literal word.

!amount:>1000                → amount column > 1000
!severity:high               → severity equals "high"
!date:2025-01..2025-06       → date in range
!price:100..500              → price between 100 and 500
!name:~^Para                 → regex match on name column (starts with "Para")

Field filters compose naturally — use them for one column, leave plain words for the rest.

Level 4 — Logic

Combine terms with OR, exclude with -, group with parentheses.

hip OR knee                  → either term matches
hip | knee                   → shorthand for OR
-consumable                  → NOT: exclude rows containing "consumable"
!cat:ortho -!s:pending       → ortho category, NOT pending status
hip (ortho | cardiac)        → hip AND (ortho OR cardiac)

Whitespace between terms is AND. OR / | between terms is OR. - in front of a term (or -!field:value) negates it.

Level 5 — Smart tokens

Natural dates that expand to real date ranges against any date column.

today                        → today's date
yesterday                    → yesterday's date
this-month                   → current month
this-year                    → current year
last-7d                      → last 7 days
last-30d                     → last 30 days

Level 6 — Aggregation hints

For findings, signals, and theses where certain shorthand is obvious in context.

CHF >10000                   → money_at_risk > 10000 (CHF prefix recognised)
3+ findings                  → finding_count >= 3
high+                        → severity at or above "high"

Parsing Rules

Whitespace splits terms (AND by default)
Quoted strings are single terms: "hip replacement"
OR or | between terms creates an OR group
- prefix negates: -term, -!field:value
!field:value is a field filter
>, <, >=, <= before a number = comparison
N..M = range (numeric or date)
Smart tokens (today, this-month, last-7d) expand to date ranges
Parentheses group OR expressions: (a | b) c

On-the-fly Help

As you type, a hint bar below the search input shows what’s valid next. The hint bar is contextual — it shows what you can write at the cursor position, not a static help text.

You type	Hint shown
(empty)	`Search... type anything, or try !field:value, >number, date..date`
`!`	`Field filter: !field:value — fields: name, cat, status, amount, date…`
`!cat:`	`Category filter: ortho, cardiac, consumable, implant…` (auto-complete)
`>`	`Greater than: >1000, >high, >2025-01-01`
`..`	`Range: 100..500, 2025-01..2025-06`
`-`	`Exclude: -consumable, -!field:value`
`OR` or `	`
`"`	`Exact phrase: "Scalpel Blade #10"`

Worked Examples

Filter 68,000 cases down to what you care about

“High-severity materials over CHF 1,000 from last year”

!severity:high !price:>1000 !date:2025-01..2025-12

Three field filters composed with implicit AND. One input, one query.

Find all ortho or cardiac cases that are not pending

!cat:ortho | !cat:cardiac -!status:pending

OR at the top level, then a negated field filter.

Find expensive recent findings

CHF >10000 last-30d

Aggregation hint + smart token. Shorthand works in finding views.

Pin a specific material

=635465

The legacy = exact-match prefix still works (backward compat).

Backward Compatibility

All existing syntax works unchanged. The v2 parser is a superset of v1:

paracetamol — contains (unchanged)
=635465 — exact match (unchanged)
!cat:ortho — field filter (unchanged)
~^MAT — regex (unchanged)

No migration required. Bookmarks saved against v1 syntax continue to work. New syntax is additive.

Explorer Guide — where search lives in the UI
Studio / Salon / Lab — why the Explorer names its pages Price Lab, Map Salon, Spend Studio

jinflow is a jazzisnow product

v0.45.1 · built 2026-04-17 08:14 UTC 