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]

Formula Operators Reference

This section provides a complete reference of all operators supported in QUALIA Rule Engine formulas.

Common Table & Field Reference

This section provides a quick reference for frequently used Business Central tables and fields in business rules. All table and field IDs have been verified against the system schema.

Placeholder Reference Guide

This section provides a comprehensive reference for all placeholder syntax, operators, functions, and special values supported by QUALIA Rule Engine.

Get Your FREE Dynamics 365 Demo

Transform your business operations with Microsoft Dynamics 365 Business Central

Experience the transformative power of Microsoft Dynamics 365 Business Central for yourself! Request a free demo today and see how our solutions can streamline your operations and drive growth for your business.

Our team will guide you through a personalized demonstration tailored to your specific needs. This draft provides a structured approach to presenting Qualia Tech's offerings related to Microsoft Dynamics 365 Business Central while ensuring that potential customers understand the value proposition clearly.

First Name*

Last Name*

Company Name*

Business Email*

Phone Number

Number Of Employees

Current Business Management System

Additional Information

Please read and confirm the following:

I consent to Qualia Tech processing my personal data to respond to my demo request and provide information about Microsoft Dynamics 365 solutions. I understand that I can withdraw my consent at any time. *

I agree to receive newsletters and marketing communications from Qualia Tech about products, services, and events. I understand I can unsubscribe at any time.

*Note: Fields marked with * are mandatory for processing your request.