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 |
|
Is not empty |
A parameter value is other than |
|
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. |