Need to create rules based on bundles?
Learn more
LogoLogo
APIsChangelog
  • Getting started
  • Rules
  • Conditions
    • Scope
    • Aggregations
    • Nested
    • Dynamic values
  • Actions
    • Types
      • Percentage
      • Fixed amount
      • Fixed price
      • Buy X pay Y
      • Every X discount Y
    • Bundle
      • Balanced
      • Every
    • Aggregation
    • Limit
  • Matchers
  • Operators
  • Check and validation
  • Core API integration
    • Order rules
    • Price rules
    • Virtual relationships
  • Resources
    • Promotions
    • Price lists
  • Use cases
    • Promotions
      • Discount line items based on item's price
      • Get a discount when paying by credit card
      • Discount an order based on promo item and total number of items
      • Offer a specific shipping method for free in a specific country
      • Discount items with large stock availability
      • Discount all the SKU in an order based on the shipping country
      • Discount all the SKU in an order based on the customer email domain
    • Price lists
      • Discount all prices greater than or equal to a specific value
      • Discount specific SKUs for new clients
      • Change strike-through price based on customer email domain
On this page

Operators

The list of available aggregation's operators based on the field type

PreviousMatchersNextCheck and validation

Last updated 5 months ago

The valid operators you can use when aggregating the or the depend on the type of field on which you want to perform the aggregation (e.g. you cannot sum strings such as tags or SKU codes).

You can find here below the complete list of the available operators:

Operator
Field type
Description

sum

Number

The sum of the field values of the all the condition's matches is compared against the provided value using the specified matcher.

min

Number

The smallest of the field values of the all the condition's matches is compared against the provided value using the specified matcher.

max

Number

The biggest of the field values of the all the condition's matches is compared against the provided value using the specified matcher.

count

StringNumber

The number of occurrences of the field value among all the condition's matches is compared against the provided value using the specified matcher.

count_uniq

StringNumberBoolean

The number of unique occurences of the field value among all the condition's matches is compared against the provided value using the specified matcher.

matches of a condition
targets of an action