Skip to content · Zum Inhalt

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]