Fields and relations
Every condition starts by choosing a field. This page explains what the field list contains and how to find things quickly in it.
The field list
Section titled “The field list”Click the bar and the field list opens. It contains every field of the current listing — for products that means Name, Stock, Price, EAN, Weight and so on. Start typing to filter the list; it narrows as you type.
Each entry is either a plain field you pick a value for, or a relation you drill into.
Relations — drilling into related records
Section titled “Relations — drilling into related records”Fields marked with a small arrow are relations: instead of a value, clicking them opens the fields of the related record. This lets you filter by things that live one step away:
- On the order list: Customer → Customer group, Billing address → Country.
- On the product list: Manufacturer → Name, Delivery time → Name.
Relations can nest a few levels deep. A breadcrumb at the top of the list shows where you are (for example Manufacturer › ), and you can step back out to the level above at any time. Type to filter within the current level just as you do at the top.
The Search entry — picking a concrete record
Section titled “The Search entry — picking a concrete record”Inside a relation you will find a Search entry at the top. Choosing it lets you pick the concrete related record rather than one of its fields — for example, a specific manufacturer or a specific customer group. The picker:
- shows thumbnails for media (such as a product’s cover image),
- offers a two-stage choice for properties (first the property group, then the option),
- scrolls on to load more results for long lists.
Shortcuts
Section titled “Shortcuts”The top of the field list also offers a few curated shortcuts to targets people reach for constantly — such as Payment status, Delivery status, Sales channel or Category — so common filters are one click away instead of a drill-down.
Favourite fields
Section titled “Favourite fields”Any field you use often can be pinned to the top of the field list. Hover a field in the list and click its heart; pinned fields appear in their own section above the rest, labelled with their full path so you can tell related fields apart. Click the heart again to unpin. Favourite fields are remembered per user, per listing.
What the list leaves out
Section titled “What the list leaves out”The field list is deliberately focused on fields you would actually filter a shop by. Purely technical fields — internal identifiers, secrets and tokens, and admin-only records that have nothing to do with your catalogue or orders — are left out so the list stays readable. If a field you expect is missing, it was almost certainly hidden on purpose.
Adding fields from related lists
Section titled “Adding fields from related lists”The depth of relations available in the list, and whether reverse and extension relations are shown, can be tuned in the Options. Leave them at their defaults unless you know you need the extra reach.