Loading
Decision Table
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

            You are here:

            1. Salesforce Help
            2. Docs
            3. Decision Tables

            Supported Data Types and Operators

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

            Required Editions

            Available in: Lightning Experience
            Available in: Enterprise, Performance, and Unlimited Editions with Loyalty Management or Rebate Management
            Note
            Note Decision tables are also available as part of Business Rules Engine. If your org has Business Rules Engine enabled, see Decision Tables for Business Rules Engine.

            These data types and operators are supported.

            Data Type Supported Operators
            Text
            • Equals
            • Not Equals
            • Matches
            Number
            • Equals
            • Not Equals
            • Less Than
            • Less or Equal
            • Greater Than
            • Greater or Equal
            AutoNumber
            • Equals
            • Not Equals
            • Matches
            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
            Checkbox
            • Equals
            • Not Equals
            Picklist
            • Equals
            • Not Equals
            • Matches
            Picklist (Multi-Select)
            • Exists In
            • Does Not Exist In
            Lookup
            • Equals
            • Not Equals
            Master Detail
            • Equals
            • Not Equals
            Email
            • Equals
            • Not Equals
            • Matches
            URL
            • Equals
            • Not Equals
            • Matches

            What Do the Operators Check?

            Operator Checks whether the input value ...
            Does Not Exist In Doesn’t exist in the value of each rule’s corresponding multi-select picklist field.
            Equals Equals the value of each rule’s corresponding field.
            Exists In Exists in the value of each rule’s corresponding multi-select picklist field.
            Greater or Equal Is greater than or equal to the value of each rule’s corresponding field.
            Greater Than Is greater than the value of each rule’s corresponding field.
            Less or Equal Is less than or equal to the value of each rule’s corresponding field.
            Less Than Is less than the value of each rule’s corresponding field.
            Matches Is a substring of the value of each rule’s corresponding field.
            Not Equals Doesn’t equal the value of each rule’s corresponding field.
             
            Loading
            Salesforce Help | Article