Formula Operators Reference
This section provides a complete reference of all operators supported in QUALIA Rule Engine formulas.
27.1 Comparison Operators Summary
Operator
Meaning
Example
is
Equals
[18:2] is 'CUST001'
is <>
Not equals
[37:15] is <>0
is >
Greater than
[18:59] is >1000
is <
Less than
[37:27] is <25
is >=
Greater than or equal
[36:20] is >=[TODAY]
is <=
Less than or equal
[37:15] is <=100
| | | |
|---|---|---|
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
27.2 Range and Multiple Value Operators
Operator
Meaning
Example
..
Range (inclusive)
[37:15] is 10..100
|
OR (multiple values)
[36:120] is '0'|'1'
| | | |
|---|---|---|
| | | |
| | | |
27.3 Pattern Matching Operators
Operator
Meaning
Example
*
Zero or more characters
[18:2] is 'CUST*'
?
Exactly one character
[27:3] is '??-????'
| | | |
|---|---|---|
| | | |
| | | |
27.4 Blank Value Operators
Operator
Meaning
Example
is ''
Field is blank
[18:2] is ''
is <>''
Field is not blank
[36:2] is <>''
| | | |
|---|---|---|
| | | |
| | | |
27.5 Mathematical Operators
Operator
Meaning
Example
+
Addition
\{[37:15] + [37:16]\}
-
Subtraction
\{[37:22] - [27:18]\}
*
Multiplication
\{[37:15] * [37:22]\}
/
Division
\{[18:59] / [18:20]\}
| | | |
|---|---|---|
| | | |
| | | |
| | | |
| | | |
27.6 Common Mistakes to Avoid
❌ Using = instead of is:
WRONG: [18:2] = 'CUST001'
RIGHT: [18:2]
❌ Using AND or OR keywords:
WRONG: [37:15] > 0 AND [37:22] > 0
RIGHT: Use two Scenarios:
Scenario 1: [37:15] is >0
Scenario 2: [37:22]
❌ Forgetting square brackets:
WRONG: 18:2 is 'CUST001'
RIGHT: [18:2]
❌ Forgetting curly braces for calculations:
WRONG: [37:15] * [37:22] is >1000
RIGHT: {[37:15] * [37:22]
❌ Wrong quotes for text values:
WRONG: [18:2] is "CUST001" (double quotes)
RIGHT: [18:2]
