Operators and values
Once a field is chosen, the bar offers an operator and then a value. Both depend on the field’s type. This page lists what you get for each.
Operators
Section titled “Operators”The operator is how the condition compares. Only the operators that make sense for the field’s type are offered:
| Operator | Reads as | Typical fields |
|---|---|---|
| is | equals exactly | any field |
| is not | not equal | any field |
| is any of | matches one of several values | relations, tags |
| is not any of | matches none of several values | relations, tags |
| contains | text includes | text fields |
| greater than / at least | above / at or above | numbers, dates |
| less than / at most | below / at or below | numbers, dates |
| between | inside a range | numbers, dates |
| is set | has any value | any field |
| is not set | is empty | any field |
Which operator a field starts on is configurable per field type in the Options — text fields default to contains, numbers and dates to between, relations to is.
When a field has only one sensible operator — a Yes/No field is always is — the operator step is skipped and the pill still shows the operator for readability (Active is Yes).
Value editors by type
Section titled “Value editors by type”The value editor changes to fit the field:
A plain text box. As you type, the bar suggests existing values from your data so you can pick a real value instead of guessing at spelling. (Text autocomplete can be turned off in the Options.) Text conditions confirm with Enter.
Numbers
Section titled “Numbers”A number box. With between, you get a From and a To box for a range; the condition applies once you confirm with Enter.
A calendar with relative presets down one side — Today, Last 7 days, Last 14 days, Last 30 days, Current month, Previous month, Last 3 months, Last 6 months, Last 12 months, Current year. A single-date operator shows one calendar; between shows two. Presets are stored relatively, so a “Last 14 days” condition always means the last 14 days each time it is applied — see Applying conditions.
Relations
Section titled “Relations”A record picker: search and choose the concrete related record. With is any of / is not any of you tick several records and confirm; with is you pick one. The picker shows thumbnails for media and scrolls on for long lists.
Yes / No
Section titled “Yes / No”A simple Yes / No choice. Selecting one completes the condition immediately.
Tags and multi-value
Section titled “Tags and multi-value”For fields that take several values you get a tag input — type a value and press Enter or comma to add it, Backspace to remove the last one.
Values that need no input
Section titled “Values that need no input”is set and is not set need no value — the condition is complete as soon as you pick the operator. The product list also offers a has duplicates condition (for EAN) that finds records sharing the same value with no value to enter; see Product list.