Skip to content
English
  • There are no suggestions because the search field is empty.

Appendix 1: Logical operators

Table: Logical operators used in the Smart Routing service

Logical operator

Description

In set

A parameter value is in the indicated set.

Not in set

A parameter value is not n the indicated set.

Equal

A parameter value is the same as the indicated value.

Not equal

A parameter value is not the same as the indicated value.

Equal to field

A parameter value is the same as the value of the parameter specified in the Value field.

Not equal to field

A parameter value is not the same as the value of the parameter specified in the Value field.

Is empty

A parameter value is null

Is not empty

A parameter value is other than null

More than

A parameter value is greater than the indicated value.

Less than

A parameter value is less than the indicated value.

More or equal than

A parameter value is the same or greater than the indicated value.

Less or equal than

A parameter value is the same or less than the indicated value.

In range

A parameter value is in the indicated value range.

Not in range

A parameter value is not in the indicated value range.

Match RegEx

The parameter value matches the specified regular expression. Using this operator requires specifying the value in the regex format.

Pay attention that when using custom fields, the system will compare the regular expression with the original field value. The field value will not be converted to the register (uppercase or lowercase) specified when creating/editing the custom field before being compared with the regular expression.

The operator is available in preconditions and regular conditions. The operator is not available in the conditions that use aggregation operators.

Not match RegEx

The parameter value does not match the specified regular expression. Using this operator requires specifying the value in the regex format.

Pay attention that when using custom fields, the system will compare the regular expression with the original field value. The field value will not be converted to the register (uppercase or lowercase) specified when creating/editing the custom field before being compared with the regular expression.

The operator is available in preconditions and regular conditions. The operator is not available in the conditions that use aggregation operators.

Aggregation operator

Count

The number of transactions with the indicated parameter.

Unique count

The number of transactions with unique values of the indicated parameter value.

Sequential count

The number of sequential transactions with the specified parameter values.

Max

The maximum value of the indicated parameter.

Min

The minimum value of the indicated parameter.

Sum

The amount of transactions with the indicated parameter.