Filtering and columns
Build your first filter
The grid opens on every shop we hold, which is not useful to anyone. A filter is how you turn that into something workable: one field, one condition, repeated until what is left is worth contacting. But nothing is charged while you build it — you are charged when you run the search, which is why the grid waits for you instead of re-querying on every change.
Pick a field
Open the filter panel and choose the field you want to constrain. Every field carries a short explanation of what it holds, so you do not have to guess the difference between two similar names.
Choose an operator
The operators offered depend on the kind of field. Text offers contains, starts with, ends with, is exactly and a pattern match. Numbers offer between, at least, at most, equals and not equals. Tag fields offer has any, has all and has none. Dropdowns let you tick several values at once, and date fields take a from and a to. Every kind also offers is empty and is not empty. But be careful with that last pair, because empty is not zero: a blank field means the value has never been measured for that shop, not that the shop has none of it.
Run the search
Apply the filter and run it. This is the point at which a search is counted, which is why changing a filter does not re-query on its own.
Read the marks on the grid
Any column currently constraining your results is highlighted in the grid, header and cells alike. With a wide table on screen that is the fastest way to see what is actually narrowing the list.
Worth knowing
- Editing a filter marks it as changed and waits for you rather than re-running immediately. That is deliberate: each run counts as a search.
Next
Try this on the real database
Free trial with the full dataset and every filter, and the allowance resets daily rather than expiring.