--- schema_version: "1" id: 8e687004b6c3601d62090c19f5d985f3b21fd2a8fccbe36250a2b729d147c57d title: Supported Data Mapper and Integration Procedure Operators collection: admin version: current locale: en-us portal_url: https://docs.salesforce.com/admin/current/en-us/xcloud/264-0-0/os_omnistudio_data_mapper_and_integration_procedure_operators.md canonical_url: https://help.salesforce.com/s/articleView?id=xcloud.os_omnistudio_data_mapper_and_integration_procedure_operators.htm&release=264.0.0&type=5 source_site: help.salesforce.com content_type: documentation content_hash: 284b78bebe2316d6d5085122eff3245caa7f7b6a588ef384c933c9153f212804 description: Use operators to develop more complex formulas for Omnistudio Data Mappers and Integration Procedures. For example, operators can perform logical, comparison, or mathematical operations on values in expressions. Operators are evaluated according to a strict precedence. products: - Omnistudio release: "264" --- # Supported Data Mapper and Integration Procedure Operators Use operators to develop more complex formulas for Omnistudio Data Mappers and Integration Procedures. For example, operators can perform logical, comparison, or mathematical operations on values in expressions. Operators are evaluated according to a strict precedence. ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-xcloud-omnistudio-264-0-0-production-enus/f526eaa8-ae05-487a-8944-4bb99b0b78ac/images/icon_note.png) Note These operators work with formulas for Omnistudio Data Mappers and Integration Procedures. For information about operators that you can use with Omniscript formulas and aggregates, see [Create a Formula or Aggregate in an Omniscript](https://help.salesforce.com/s/articleView?id=xcloud.os_create_a_formula_or_aggregate_in_an_omniscript_23115.htm&release=264.0.0&type=5 "Create expressions to set calculated values and evaluate data across multiple fields using a Formula or Aggregate element. For example, if you are accepting information for a qualifying life event you may want to create a formula that determines if the date entered for the qualifying life event is within thirty days of today's date."). - **[Omnistudio Operators](https://help.salesforce.com/s/articleView?id=xcloud.os_omnistudio_data_mapper_and_integration_procedure_operators.htm&release=264.0.0&type=5)** Omnistudio operators are grouped into categories: logical, comparison, mathematical, string, and precedence. The categories reflect the role each type of operator performs in a Data Mapper or Integration Procedure formula. - **[Omnistudio Operator Precedence](https://help.salesforce.com/s/articleView?id=xcloud.os_omnistudio_data_mapper_and_integration_procedure_operators.htm&release=264.0.0&type=5)** Precedence indicates the order in which the engine evaluates Omnistudio operators in expressions in Data Mapper and Integration Procedure formulas. ## Omnistudio Operators Omnistudio operators are grouped into categories: logical, comparison, mathematical, string, and precedence. The categories reflect the role each type of operator performs in a Data Mapper or Integration Procedure formula. ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-xcloud-omnistudio-264-0-0-production-enus/f526eaa8-ae05-487a-8944-4bb99b0b78ac/images/icon_note.png) Note Documentation about Omnistudio operators was updated Summer '25: - The `=` operator is an equality operator, not an assignment operator. - All string comparisons with operators are case-insensitive. For strings, the `==`, `=`, and `~=` operators return the same results. - The `NOT` logical complement operator was added to the documentation. - The `%` remainder operator was removed from the documentation. Logical operators return either true or false depending on the values and expressions they evaluate. They don't accept `NULL` values, and they can never return `NULL`.

Operator

Syntax

Description

&&

AND

x && y

x AND y

AND logical operator. If both x and y evaluate to true, the expression evaluates to true. Otherwise, the expression evaluates to false.

||

OR

x || y

x OR y

OR logical operator. If both x and y evaluate to false, the expression evaluates to false. Otherwise, the expression evaluates to true.

NOT

NOT(x)

NOT(x == y)

Logical complement operator. Inverts the value of a Boolean value or expression so that true becomes false and false becomes true. If x is true, the operator inverts its Boolean value to false. If x is equal to y, the operator inverts the evaluation of the expression to false.

Comparison operators return either true or false depending on the values and expressions they evaluate. All mathematical comparisons are based on numeric value. All string comparisons are case-insensitive and lexicographical. Comparison operators treat dates and times as strings, so don't rely on them to compare dates and times. A comparison can never return `NULL`.

Operator

Syntax

Description

>

x > y

Greater than operator. If x is greater than y, the expression evaluates to true. Otherwise, the expression evaluates to false.

>=

x >= y

Greater than or equal to operator. If x is greater than or equal to y, the expression evaluates to true. Otherwise, the expression evaluates to false.

<

x < y

Less than operator. If x is less than y, the expression evaluates to true. Otherwise, the expression evaluates to false.

<=

x <= y

Less than or equal to operator. If x is less than or equal to y, the expression evaluates to true. Otherwise, the expression evaluates to false.

==

=

x == y

x = y

Equality operator. If x is equal to y, the expression evaluates to true. Otherwise, the expression evaluates to false.

!=

<>

x != y

x <> y

Inequality operator. If x is not equal to y, the expression evaluates to true. Otherwise, the expression evaluates to false.
Mathematical operators return a number, which can be an integer or a decimal value. If either operand is a decimal value, the result is a decimal value.

Operator

Syntax

Description

+

x + y

Addition operator. Adds the value of x to the value of y.

-

x - y

Subtraction operator. Subtracts the value of x from the value of y.

*

x * y

Multiplication operator. Multiplies the value of x by the value of y.

/

x / y

Division operator. Divides the value of x by the value of y. If the operation results in a fraction, the result is a decimal value.

^

x ^ y

Exponential operator. Raises the value of x to the power of y. For example, 2 ^ 3 results in 8.
String operators return either true or false depending on the strings they evaluate. They don't accept NULL values, and they can never return NULL.

Operator

Syntax

Description

LIKE

x LIKE y

Case-insensitive substring operator. If x contains y (if y is a substring of x), the expression returns true. Otherwise, it returns false. For example, "ABC" LIKE "A" and "ABC" LIKE "a" both return true.

NOTLIKE

x NOTLIKE y

Case-insensitive substring complement operator. If x does not contain y (if y is not a substring of x), the expression returns true. Otherwise, it returns false. For example, "ABC" NOTLIKE "A" and "ABC" NOTLIKE "a" both return false.

~=

x ~= y

Case-insensitive string equality operator. If x and y are the same string regardless of case, the expression returns true. Otherwise, it returns false. For example, "ABC" ~= "abc" returns true.
The precedence operator causes an expression to be evaluated with higher precedence.

Operator

Syntax

Description

( )

(x = y)

(x + y)

Precedence operator. Elevates the precedence of the expression x so that it's evaluated first in a compound expression. Precedence operators can be nested.
## Omnistudio Operator Precedence Precedence indicates the order in which the engine evaluates Omnistudio operators in expressions in Data Mapper and Integration Procedure formulas. Operators in higher rows have precedence over operators in lower rows. For example, the `()` operator appears in the top row of the table and has a precedence value of 1. It is always given the highest precedence. Operators in the same row have equivalent precedence; in an expression, they're evaluated left to right in the order in which they appear.

Precedence

Operators

Description

1

( )

Precedence operator

2

NOT

Logical complement operator

3

^

Exponential operator

4

* /

Multiplication and division operators

5

+ -

Addition and subtraction operators

6

> >= < <=

Greater-than and less-than comparison operators

7

== = != <>

Equality and inequality comparison operators

8

LIKE NOTLIKE ~=

String comparison operators

9

&& AND

AND logical operators

10

|| OR

OR logical operators