This guide explains how to use filters with multiple-select fields effectively. These filters allow you to include, exclude, or precisely match records based on selected options.
Below, the examples use a Product Category field to illustrate how each filter works.
Field Example: Product Category
Options: ["Electronics", "Furniture", "Books", "Decor"]
1. Has any of
Definition: Finds records where at least one of the specified options is selected.
Example:
Filter: Has any of ["Electronics", "Books"]
Matches: Products tagged
["Electronics"],["Books"], or["Electronics", "Furniture"].Doesn't Match: Products tagged
["Furniture", "Decor"]or with no tags.
2. Has None of
Definition: Finds records where none of the specified options are selected.
Example:
Filter: Has None of ["Electronics", "Books"]
Matches: Products tagged
["Furniture"],["Decor"], or with no tags.Doesn't Match: Products tagged
["Electronics"],["Books"], or["Electronics", "Furniture"].
3. Has all of
Definition: Finds records that include all the specified options (other selections may also be present).
Example:
Filter: Has all of ["Furniture", "Decor"]
Matches: Products tagged
["Furniture", "Decor"]or["Electronics", "Furniture", "Decor"].Doesn't Match: Products tagged
["Furniture"],["Decor"], or["Books"].
4. Hasn't all of
Definition: Finds records that do not include all the specified options (they may have some, none, or others).
Example:
Filter: Hasn't all of ["Furniture", "Decor"]
Matches: Products tagged
["Furniture"],["Decor"], or["Electronics"].Doesn't Match: Products tagged
["Furniture", "Decor"]or["Furniture", "Decor", "Books"].
5. Is included in
Definition: Finds records where all selected options are entirely contained within the specified list.
Example:
Filter: Is included in ["Furniture", "Decor"]
Matches: Products tagged
["Furniture"],["Decor"], or["Furniture", "Decor"].Doesn't Match: Products tagged
["Electronics", "Furniture"]or["Books"].
6. Is not included in
Definition: Finds records where the selected options include items not in the specified list.
Example:
Filter: Is not included in ["Furniture", "Decor"]
Matches: Products tagged
["Electronics"]or["Furniture", "Books"].Doesn't Match: Products tagged
["Furniture"],["Decor"], or["Furniture", "Decor"].
7. Equals
Definition: Finds records that exactly match the specified options (no more, no less).
Example:
Filter: Equals ["Furniture", "Decor"]
Matches: Products tagged
["Furniture", "Decor"].Doesn't Match: Products tagged
["Furniture"],["Decor"], or["Furniture", "Decor", "Books"].
8. Not equals
Definition: Finds records that do not exactly match the specified options.
Example:
Filter: Not equals ["Furniture", "Decor"]
Matches: Products tagged
["Furniture"],["Decor"], or["Furniture", "Decor", "Books"].Doesn't Match: Products tagged
["Furniture", "Decor"].
How to Use These Filters
Broad Matches: Use Has any of or Has all of to include a wide range of records.
Exclusions: Use Has None of or Hasn't all of to remove unwanted records.
Precise Matches: Use Equals for exact matches or Is included in for subset matches.
Mismatch Detection: Use Not equals or Is not included in to find records that deviate from your criteria.
By combining these filters, you can create powerful queries to identify exactly the records you need.