Filter operators
Filter operators define the behaviour of a product filter, as they control the condition that decides whether or not a product is included in the filter result.
There are several types of filter operators, some are available across all filter data types while others are data type specific and therefore only available for specific types of product filters.
Reference
All product filter operators categorized per filter type are listed below.
Attribute operators
Attribute operators are available for attribute type filters only. They can be set on attribute level, which means no filter value is used for these operators.
Icon |
Operator name |
Description |
Example use case |
|
Is absent |
Matches products which don't have the selected attribute assigned, either directly or on a master level |
Find all products that don't have the Color attribute assigned |
|
Is blank |
Matches products which have the selected attribute assigned or which have a master that has the attribute assigned, but where no value is set for the selected attribute |
Find all products that have the Color attribute assigned but without a value set |
|
Is not blank |
Matches products which have the selected attribute assigned or which have a master that has the attribute assigned and where the selected attribute contains a value |
Find all products that have a value the Color attribute |
|
Is absent directly on product |
Matches products which don't have the selected attribute directly assigned, but which may have the selected attribute assigned on a master level |
Find all variant products that don't have the Color attribute assigned |
|
Has no value directly on product |
Matches products which have the selected attribute assigned or which have a master that has the attribute assigned, but where no value is set for the selected attribute directly on the product |
Find all variant products that have the Color attribute assigned but without a value set |
|
Has value directly on product |
Matches products which have the selected attribute directly assigned or which have a master that has the attribute assigned and where the selected attribute contains a value directly on the product |
Find all variant products that have a value the Color attribute |
Field type specific operators
Field type specific operators are applied on attribute field level, which means they take the data type of the attribute field into account and define a condition based on that. Field type specific operators require one or more user provided values in order to create a condition for the attribute field. The amount of values to be provided is depending on the type of operator.
Note
All field level operators use matching on the product's entire master hierarchy. This means that values inherited from a master of the product are matched as well as values directly on the product itself.
Numeric operators
Numeric PIM types
- PDecimal1
- PDecimal2
- PDecimal3
- PDecimal4
- PDecimal5
- PDecimal6
- PDecimal7
- PDecimal8
- PDecimal9
- PInt16
- PInt32
- PInt64
- PChannelSpecificDecimal2
- PChannelSpecificDecimal2D
- PChannelSpecificInt32
- PChannelSpecificInt32D
- PTranslationCultureSpecificDecimal2
- PTranslationCultureSpecificDecimal2D
Icon |
Operator name |
Description |
Example use case |
|
Equals |
Matches products which have a value for the selected attribute that equals the provided value |
Find all products with a Length of 100 cm |
|
Not equals |
Matches products which have a value for the selected attribute that does not equal the provided value |
Find all products with a Length other than 100 cm |
|
Is less than |
Matches products which have a value for the selected attribute that is less than the provided value |
Find all products with a Length less than 100 cm |
|
Is less than or equals |
Matches products which have a value for the selected attribute that is less than or equal to the provided value |
Find all products with a Length less than or equal to 100 cm |
|
Is greater than |
Matches products which have a value for the selected attribute that is greater than the provided value |
Find all products with a Length greater than 100 cm |
|
Is greater than or equals |
Matches products which have a value for the selected attribute that is greater than or equal to the provided value |
Find all products with a Length greater than or equal to 100 cm |
|
Is any of |
Matches products which have a value for the selected attribute that equals one of the provided values |
Find all products with a Length of either 100 cm, 200 cm or 300 cm |
|
Is between |
Matches products which have a value for the selected attribute that lies between the provided minimum and maximum boundary values (both are inclusive) |
Find all products with a Length of between 100 cm and 200 cm |
Text operators
Text based PIM types
- PString
- PTranslatedString
- PTranslatedStringD
- PChannelSpecificString
- PChannelSpecificStringD
Icon |
Operator name |
Description |
Example use case |
|
Contains |
Matches products which value for the selected attribute contains a word that contains or equals the provided value |
Find all products with a Description that includes a word which contains contain |
|
Does not contain |
Matches products which value for the selected attribute does not contain a word that contains or equals the provided value |
Find all products with a Description that does not contain a word which contains contain |
|
Starts with |
Matches products which value for the selected attribute contains a word that starts with or equals the provided value |
Find all products with a Description that contain a word starting with start |
|
Ends with |
Matches products which value for the selected attribute contains a word that ends with or equals the provided value |
Find all products with a Description that contain a word ending with or equal to end |
|
Equals |
Matches products which have a value for the selected attribute that equals the provided value |
Find all products where the EAN code is 8468260096911 |
|
Not equals |
Matches products which have a value for the selected attribute that does not equal the provided value |
Find all products where the EAN code is not 8468260096911 |
|
Is any of |
Matches products which have a value for the selected attribute that equals one of the provided values |
Find all products with an EAN code of either 8468260096911 , 4602910667678 or 6100732780196 |
Date time operators
Date time PIM types
- PDateTime
- PDateTimeOffset
Icon |
Operator name |
Description |
Example use case |
|
Equals |
Matches products which have a value for the selected attribute that equals the provided value |
Find all products which are Available from October 31, 2023 |
|
Not equals |
Matches products which have a value for the selected attribute that does not equal the provided value |
Find all products which are Available from any other date than October 31, 2023 |
|
Is before |
Matches products which have a value for the selected attribute that is before the provided value |
Find all products which are Available from any date before October 31, 2023 |
|
Is before or equals |
Matches products which have a value for the selected attribute that is before or equal to the provided value |
Find all products which are Available from any date before or exactly October 31, 2023 |
|
Is after |
Matches products which have a value for the selected attribute that is after the provided value |
Find all products which are Available from any date after October 31, 2023 |
|
Is after or equals |
Matches products which have a value for the selected attribute that is greater than or equal to the provided value |
Find all products which are Available from any date after or exactly October 31, 2023 |
|
Is between |
Matches products which have a value for the selected attribute that lies between the provided minimum and maximum boundary values (both are inclusive) |
Find all products which are Available from any date between October 1, 2023 and October 31, 2023 |
Boolean operators
Boolean PIM types
- PBoolean
- PChannelSpecificBoolean
- PChannelSpecificBooleanD
- PTranslationCultureSpecificBoolean
- PTranslationCultureSpecificBooleanD
Icon |
Operator name |
Description |
Example use case |
|
Is true |
Matches products where the value for the selected attribute is true |
Find all products where Ready for web is set to true |
|
Is false |
Matches products where the value for the selected attribute is false |
Find all products where Ready for web is set to false |
Info
Boolean operators don't require the user to set a value, as the value (either true
or false
) is a part of the operator itself.
Global list operators
Icon |
Operator name |
Description |
Example use case |
|
Equals |
Matches products which have a value for the selected attribute that equals the provided value |
Find all products where the Color is Red |
|
Not equals |
Matches products which have a value for the selected attribute that does not equal the provided value |
Find all products where the Color is any other than Red |
|
Is any of |
Matches products which have a value for the selected attribute that equals one of the provided values |
Find all products which Color is either Red , Blue or Green |
|
Is not any of |
Matches products which have a value for the selected attribute that does not equal one of the provided values |
Find all products which Color is other than either Red , Blue or Green |
Logical operators
Logical operators are operators that link two or more filters and define how the complete filter should be interpreted.
Bizzkit PIM supports logical operators AND
and OR
. Here's how to use them to create search queries:
Operator name |
Description |
Example use case |
AND |
Combines two filters by making the combination of the two match products |
Find products with a Color that is Blue and in the Category Clothing |
OR |
Combines two filters by making sure one of the two match products |
Find products in the Category Clothing or which are of Type Clothing |
Note
The OR
logical operator can only be used in the Advanced
filters, whereas the AND
logical operator is available in both the Basic
and Advanced
filters.
Tip
When creating multiple filters on the same attribute using the equals
operator which are connected with OR
as logical operator, consider using a single filter with the is any of
operator instead.
Standard filters operators
Unique name
Icon |
Operator name |
Description |
Example use case |
|
Equals |
Matches products which have a Unique name that equals the provided value |
Find all products where the Unique name is 8468260096911 |
|
Starts with |
Matches products which Unique name contains a word that starts with or equals the provided value |
Find all products with a Unique name that contain a word starting with 846 |
|
Contains |
Matches products which Unique name contains a word that contains or equals the provided value |
Find all products with a Unique name that includes a word which contains 2600 |
|
Is any of |
Matches products which have a Unique name that equals one of the provided values |
Find all products with a Unique name of either 8468260096911 , 4602910667678 or 6100732780196 |
Category
Icon |
Operator name |
Description |
Example use case |
|
Not equals |
Matches products which are in a category that does not equal the provided value or which are not placed in any category at all |
Find all products which are placed in another category than Clothing , or which are not placed in any category at all |
|
Equals |
Matches products which are placed in a category that equals the provided value |
Find all products which are placed in the Clothing category |
|
Is any of |
Matches products which are placed in a category that equals (at least) one of the provided values |
Find all products which are placed in the Clothing category or the Accessories category |
|
Is absent |
Matches products which are not placed in any category at all |
Find all products which are not placed in any category at all |