MyLeadFox

Filtering and columns

Combine filters with and, or and not

Each filter carries its own connector. Together they resolve by one rule, and that rule is worth understanding because it is what stops a filter set from quietly returning far more than you asked for.

  1. Mark the things that must be true

    Leave a filter set to and. Every filter marked this way must match. These are your requirements.

  2. Mark the alternatives

    Set a filter to or when it is one of several acceptable options. At least one filter marked or must match, and they are considered together as a group.

  3. Mark the exclusions

    Set a filter to not to remove matches. None of the filters marked this way may match.

  4. Use the search box for anything global

    The search box always narrows the whole expression. It cannot be widened by an alternative elsewhere in the set, so it behaves the same however the rest of the filters are arranged.

Worth knowing

  • Reordering your filters cannot change your results. Position carries no meaning, so a card is not affected by which cards happen to sit next to it.
  • This is not the arithmetic rule where and binds tighter than or. That rule cannot express "any of these three, and also this one", because the extra condition can only attach to one alternative. Measured on the live database, a real filter set returns 911 shops under the rule used here and 38,969 under the alternative, with the extra condition silently ignored for six of seven fields.

Next

Use regex in a filterMatch patterns, and combine several of them inside one fieldBuild your first filterNarrow eight million shops down to the ones worth contactingDescribe 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