MyLeadFox

Filtering and columns

Build your first filter

A filter is one field plus one condition. You add as many as you need, and the grid narrows as you apply them. Nothing is charged while you are building the filter; you are charged when you run the search.

  1. 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.

  2. 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.

  3. 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.

  4. 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

  • Empty is not zero. A blank field means the value has not been measured or generated for that shop, not that the shop has none of it. Filtering on is empty finds the former.
  • 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

Combine filters with and, or and notExpress requirements, alternatives and exclusions in one filter setChoose which columns you seeShow the fields you work with, and save that as your defaultDescribe a search in your own wordsType what you are looking for and get a real filter set you can check before applying

Try this on the real database

Free trial with the full dataset and every filter, and the allowance resets daily rather than expiring.

Start freeSee pricing