Understand attribute filters and operators

Prev Next

The Add Filter in the Products and Digital Assets page allows you to refine search results by applying filters on various attributes.

Each attribute type, such as Text, Nested, Boolean, Date/Date Time, Reference List (LOV), Taxonomy/Classification, and Integer/Decimal supports a predefined set of operators. These operators define how the search value(s) must be evaluated using logical conditions such as OR, AND, and NOT.

Filter by text attribute

A text attribute allows you to filter products by entering one or more values and applying supported operators.

The text attribute supports the following operators for single and multi-value.

Single Value Multi Value
pxc pxc
Operators Description Attribute Property
Matches Displays products that match the specified value(s), using the OR condition.
For example, filter products by Product Name attribute that matches “Sweater” or “Jacket” in the attribute value.
Single value
Does Not Match Displays products that do not match the specified value(s), using the OR condition.
For example, filter products by Product Name attribute that do not match “Sweater” or “Jacket” in the attribute value.
Single value
Matches Any Displays products that match any one or more specified value(s), using the OR condition.
For example, filter products by Tags attribute that have either “Casual”, “Daily Wear”, or “Comfortable”, or multiple of these as the attribute value.
Multi-value
Does Not Match Any Displays products that do not match any one or more specified value(s), using the OR condition.
For example, filter products by Tags attribute that do not have either “Casual”, “Daily Wear”, or “Comfortable”, or multiple of these as the attribute value.
Multi-value
Matches All Displays products that match all of the specified value(s), using the AND condition.
For example, filter products by Tags attribute that have both “Casual” and “Comfortable” as the attribute value.
Multi-value
Do Not Match All Displays products that do not match all of the specified value(s), using the AND condition.
For example, filter products by Tags attribute that do not have both “Casual” and “Comfortable” as the attribute value.
Multi-value
Has Value Displays products that have a value(s).
For example, filter products by Tags attribute that have value(s).
Single and multi-value
Has No Value Displays products that do not have a value.
For example, filter products by Tags attribute that do not have a value.
Single and multi-value

Filter by nested attribute

A nested attribute allows you to filter products by one or more child attributes and apply supported operators.

The nested attribute supports the following operators.

pxc

Operators Description
Match in the Same Row Displays products that match the specified value(s) in the same row.
For example, filter products by Address attribute that match Country and State in the same row.
Match Across Rows Displays products that match the specified value(s) across rows.
For example, filter products by Address attribute that match Country or State across rows.
Has Value Displays products that have a value(s).
For example, filter products by Address attribute that have a value(s).
Has No Value Displays products that do not have a value.
For example, filter products by Address attribute that do not have a value.

Filter by boolean attribute

A boolean attribute allows you to filter products by selecting a boolean value, such as True or False, Yes or No, as a filter criterion.

The boolean attribute supports the following operators.

pxc

Operators Description
Is Displays products that match the selected boolean value.
For example, filter products by Is Discountable attribute that have Yes as the attribute value.
Is Not Displays products that do not match the selected boolean value.
For example, filter products by Is Discountable attribute that do not match Yes.
Has Value Displays products that have a value.
For example, filter products by Is Discountable attribute that have any value(s).
Has No Value Displays the products that do not have a value.
For example, filter products by Is Discountable attribute that do not have a value.

Filter by date or datetime attribute

A date or datetime attribute allows you to filter products by a specific date and time or in a specified date and time range.

You can either select the date or date range manually from the calendar, or select from the predefined options in the left pane of the popover. Upon selection, the dates between the start and end dates are highlighted in light blue.

The date or date time attribute displays the following predefined filters.

Date Filters Description
Range You can select any of the predefined date ranges, such as ‘Last 30 Mins’, ‘Last 4 Hours’, ‘Last 1 Day’, ‘Last 3 Days’, ‘Last 1 Week’, ‘Last 1 Month’, or ‘Last 3 Months’.
Custom You can define a custom value for the ‘Last’ field and select the criteria (minutes, hours, days, weeks, months, or years) from the dropdown.
Explicit You can select any of the following options:
  • After a date: Displays products from the selected date and time till the current system date and time.
  • Before a date: Displays products beyond the selected date and time.
  • Exact date: Displays products for the selected date and time.

pxc

The date or date time attribute supports the following operators.

Operators Description
Is Displays products that match the specified date or that lie between the specified date range.
For example, filter products by Created Date attribute on “11/11/2025” or date range between “11/11/2025 - 21/11/2025”.
Is Not Displays products that do not match the specified date or that do not lie between the specified date range.
For example, exclude products by Created Date attribute on “11/11/2025” or date range between “21/11/2025 - 21/11/2025”.
Has Value Displays products that have a value.
For example, filter products by Created Date attribute that have any value.
Has No Value Displays the products that do not have a value.
For example, filter products by Created Date attribute that do not have a value.

Filter by reference list (LOV) attribute

A reference list attribute allows you to filter products by selecting one or more values from the list and applying the supported operators.

The reference list (LOV) attribute supports the following operators for both single and multi-value.

pxc

Operators Description Attribute Property
Is Displays products that exactly match the selected value(s), using the OR condition.
For example, filter products by Product Status attribute that have “New” or “In progress” as the attribute value.
Single value
Is Not Displays products that do not exactly match the selected value(s), using the OR condition.
For example, filter products by Product Status attribute that do not have “New” or “In progress” as the attribute value.
Single value
Is Any Displays products that match any one or more selected value(s), using the OR condition.
For example, filter products by Color attribute that have either “Red”, “Blue”, or “Green”, or multiple of these as the attribute value.
Multi-value
Is Not Any Displays products that do not match any one or more selected value(s), using the OR condition.
For example, filter products by Color attribute that do not have either “Red”, “Blue”, or “Green”, or multiple of these as the attribute value.
Multi-value
Is All Displays the products that match all of the selected value(s), using the AND condition.
For example, filter products by Color attribute that have all of the selected values such as “Red”, “Blue”, and “Green” in the attribute value.
Multi-value
Is Not All Displays products that do not match all of the selected value(s), using the AND condition.
For example, filter products by Color attribute that do not have all of the selected values such as “Red”, “Blue”, and “Green” in the attribute value.
Multi-value
Has Value Displays products that have any value(s).
For example, filter products by Color attribute that have a value(s).
Single and multi-value
Has No Value Displays the products that do not have a value.
For example, filter products by Color attribute that do not have a value.
Single and multi-value

Filter by taxonomy/classification attribute

A taxonomy/classification attribute allows you to filter products by selecting a classification(s) and applying the supported operators.

The taxonomy/classification attribute supports the following operators for both single and multi-value.

pxc

Operators Description Attribute Property
Is Displays products that match the selected classification(s), using the OR condition.
For example, filter products by Web Taxonomy attribute that match the following classifications:
  • “Jewelry and Watches >> Jewelry >> Men >> Bracelet”
  • “Jewelry and Watches >> Jewelry >> Men >> Ring”
Single value
Is Not Displays products that do not match the selected classification(s), using the OR condition.
For example, filter products by Web Taxonomy attribute that do not match the following classifications:
  • “Jewelry and Watches >> Jewelry >> Men >> Bracelet”
  • “Jewelry and Watches >> Jewelry >> Men >> Ring”
Single value
Is Any Displays products that match any one or more selected classification(s), using the OR condition.
For example, filter products by Web Taxonomy attribute that match any one or more classifications as the attribute value:
  • “Apparel & Footwear >> Men >> Shoes”
  • “Apparel & Footwear >> Women >> Shoes”
Multi-value
Is Not Any Displays products that do not match any one or more selected classification(s), using the OR condition.
For example, filter products by Web Taxonomy attribute that do not match any one or more classifications as the attribute value:
  • “Apparel & Footwear >> Men >> Shoes”
  • “Apparel & Footwear >> Women >> Shoes”
Multi-value
Is All Displays the products that match all of the selected classification(s), using the AND condition.
For example, filter products by Web Taxonomy attribute that have all of the classifications as the attribute value:
  • “Apparel & Footwear >> Men >> Shoes”
  • “Apparel & Footwear >> Women >> Shoes”
Multi-value
Is Not All Displays products that do not match all of the selected classification(s), using the AND condition.
For example, filter products by Web Taxonomy attribute that do not have all of the selected classifications as the attribute value:
  • “Apparel & Footwear >> Men >> Shoes”
  • “Apparel & Footwear >> Women >> Shoes”
Multi-value
Has Value Displays products that have a value.
For example, filter products by Web Taxonomy attribute that have any value(s).
Single and multi-value
Has No Value Displays the products that do not have a value.
For example, filter products by Web Taxonomy attribute that do not have any value.
Single and multi-value

Integer/Decimal

An integer/decimal attribute allows you to filter products by providing a numeric value with or without decimals using any of the supported operators. Additionally, for a UOM attribute, you can select a unit from the dropdown.

The integer/decimal attribute supports the following operators for both single and multi-value.

pxc

When you select In Range or Not In Range from the dropdown, you can view the Min and Max fields to search based on “greater than”, “less than”, or “in range” conditions.

Operators Description Attribute Property
Is Displays products that exactly match the specified value(s), using the OR condition.
For example, filter products by Volume attribute that have “100 mm3” or “200 mm3” as the attribute value.
Single value
Is Not Displays products that do not match the specified value(s), using the OR condition.
For example, filter products by Volume attribute that do not have “100 mm3” or “200 mm3” as the attribute value.
Single value
Is Any Displays products that match any one or more specified value(s), using the OR condition.
For example, filter products by Volume that have either “100 mm3”, “200 mm3” or “300 mm3”, or multiple of these as the attribute value.
Multi-value
Is Not Any Displays products that do not match any one or more specified value(s), using the OR condition.
For example, filter products by Volume attribute that have either “100 mm3”, “200 mm3” or “300 mm3”, or multiple of these as the attribute value.
Multi-value
Is All Displays the products that match all of the specified value(s), using the AND condition.
For example, filter products by Volume attribute that have all of the specified values, such as “100 mm3”, “200 mm3” and “300 mm3” as the attribute value.
Multi-value
Is Not All Displays products that do not match all of the specified value(s), using the AND condition.
For example, filter products by Volume attribute that do not have all of the specified values, such as “100 mm3”, “200 mm3” and “300 mm3” as the attribute value.
Multi-value
In Range Displays products that fall in the range specified in the Min and Max fields.
For example, filter products by Volume attribute that fall between “100 mm3” and “500 mm3”.
Single and multi-value
Not In Range Displays products that do not fall in the range specified in the Min and Max fields.
For example, filter products by Volume attribute that fall between “100 mm3” and “500 mm3”.
Single and multi-value
Has Value Displays products that have any value(s).
For example, filter products by Volume attribute that have a value(s).
Single and multi-value
Has No Value Displays the products that do not have a value.
For example, filter products by Volume attribute that do not have a value.
Single and multi-value