Loading
Feature Disruption - Service Cloud VoiceRead More
Feature degradation | Gmail Email delivery failureRead More
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            Supported Data Mapper and Integration Procedure Operators

            You are here:

            1. Salesforce Help
            2. Docs
            3. Omnistudio

            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
            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.
            • 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.
            • Omnistudio Operator Precedence
              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
            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
             
            Loading
            Salesforce Help | Article