Loading
Business Rules Engine
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 Types and Operators in Decision Tables

            You are here:

            1. Salesforce Help
            2. Docs
            3. Business Rules Engine

            Supported Data Types and Operators in Decision Tables

            Decision tables support specific field types as inputs and outputs. A field’s data type determines the field's available operators.

            Required Editions

            Available in: Lightning Experience
            Available in: Enterprise, Unlimited, and Developer Editions for clouds that have Business Rules Engine enabled
            Note
            Note If you use decision tables as part of Loyalty Management or Rebate Management, see Decision Table.

            Here are the supported data types and operators in decision tables:

            Data Type Supported Operators
            Text
            Number
            • Equals
            • Not Equals
            • Less Than
            • Less or Equal
            • Greater Than
            • Greater or Equal
            AutoNumber
            Percentage
            • Equals
            • Not Equals
            • Less Than
            • Less or Equal
            • Greater Than
            • Greater or Equal
            Date
            • Equals
            • Not Equals
            • Less Than
            • Less or Equal
            • Greater Than
            • Greater or Equal
            Date/Time
            • Equals
            • Not Equals
            • Less Than
            • Less or Equal
            • Greater Than
            • Greater or Equal
            Currency
            • Equals
            • Not Equals
            • Less Than
            • Less or Equal
            • Greater Than
            • Greater or Equal
            Checkbox
            • Equals
            • Not Equals
            Picklist
            Picklist (Multi-Select)
            • Exists In
            • Does Not Exist In

            For multi-select picklist fields, you can pass only one input value during a lookup.

            For example, imagine you have a multi-select picklist field called "Genre" that stores the genres applicable to a book. This field has the following picklist values:

            • Genre1 includes ART and LITERATURE
            • Genre2 includes SCIENCE, FINE ART, and FICTION
            • Genre3 includes LITERATURE and SCIENCE FICTION

            When you pass an input value for EXISTS IN:

            If the input is "Art," there is no match because the lookup is case sensitive. If the input is "ART," it matches Genre1. If the input is "FINE ART," it matches Genre2. If the input is "LITERATURE," it matches both Genre1 and Genre3.

            When you pass an input value for DOES NOT EXIST IN:

            If the input is "MYSTERY," it matches all genres because "MYSTERY" is not in any of the picklist values. If the input is "LITERATURE," it matches Genre2 because "LITERATURE" is not in Genre2. If the input is "Art," it matches all genres because the lookup is case sensitive and "Art" does not match "ART."

            Lookup
            • Equals
            • Not Equals
            Master Detail
            • Equals
            • Not Equals
            Email
            URL
            • Matches Operator in Decision Tables
              Use the Matches operator to retrieve an output if the query value is an exact match or a subset of the decision table row value. The Matches operator is case-sensitive and applies only to input fields in the decision table.
            • Does Not Match Operator in Decision Tables
              Use the Does Not Match operator to retrieve an output if the query value does not match the decision table row value and is also not a subset of the decision table row value. The Does Not Match operator is case-sensitive and applies only to input fields in the decision table.
            • Contains Operator in Decision Tables
              Use the Contains operator to retrieve an output if the decision table row value is an exact match or subset of the query value. The Contains operator is case-sensitive and applies only to input fields in the decision table.
             
            Loading
            Salesforce Help | Article