Build an advanced filtering query

Build explicit filtering logic in Advanced filter operators mode. Use AND and OR operators, condition groups, and include or exclude rules to define which variants appear in the results.

Use this mode when variants must match all filters, any filter, or a grouped subset of filters.

To understand the logic behind advanced filtering, see How filtering works in the Advanced filter operators mode.

Start a filtering query

1

Open the Filters tab.

2

Switch to Advanced filter operators mode.

3

Select the logical operator for the top level:

• AND: All filters and condition groups on the top level must match

• OR: Any filter or condition group on the top level can match

Nested condition groups may have a different operator.

4

The starting point is an empty condition group.

Next:

• Add individual criteria to the query according to the guide below.

• Add a set of filters under a logical operator — on the same level or nested — according to the guide below.

Result: An empty condition group is created under the top-level operator you selected.

---

Filters

Use filters to add individual criteria to the query with the include or exclude rule.

• Add a filter

• Configure a filter

• Remove a filter

Add a filter

Add a filter inside a condition group

Adding a filter to the condition group

1

Select + Add filter in the condition group frame.

2

Proceed to configuring the filter.

Result: The filter is added to the condition group.

Add an individual filter on the same level as a condition group

Adding a filter on the same level as the condition group

1

Select + Add filter outside the group frame.

2

Proceed to configuring the filter.

Result: The filter is added on the same level as the previous filter or condition group.

Configure a filter

1

In the filter selector field, enter text to search for a filter.

Refer to the filter list for Advanced filter operators mode.

2

Select the filter from the dropdown.

3

Set a condition according to filter type.

4

Optional: Toggle on Exclude to remove matching variants. Include is set by default. Some filters support Include only.

Result: The filter condition is added to the query.

Remove a filter

Select Remove filter () next to the filter.

Result: The filter is removed from the query.

---

Condition groups

Use condition groups to apply one logical operator to a set of filters or nested condition groups. You can add condition groups on the same level or nest a condition group inside another group.

• Add a condition group

• Configure a condition group

• Remove a condition group

Add a condition group

Add a condition group on the same level

Adding a condition group on the same level

1

Select + Add group immediately outside the group frame.

2

Proceed to configuring a condition group.

Result: The condition group is added on the same level as the previous filter or condition group.

Add a nested condition group

Adding a nested condition group

1

Select + Add group inside the condition group.

2

Proceed to configuring a condition group.

Result:

• The condition group is added inside the condition group.

• Background colors alternate by nesting level, so each inner group is visually distinct from its outer group.

Configure a condition group

1

Select the group operator:

• AND: All filters and condition groups inside the group must match

• OR: Any filter or condition group inside the group can match

Any groups nested inside the group have an independent operator.

2

Next, you can add filters to the condition group or add a nested condition group.

Result: The group operator applies to the filters and condition groups inside the condition group.

Remove a condition group

Select Remove group () in the top-right corner of the condition group.

Result: The condition group and all filters or nested groups inside it are removed from the query.

Result

With each change to the query, the variant table updates to display variants that match the complete filtering logic.