Loading
Business Rules Engine
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:

Note
Note To view data types supported in CSV-based decision tables, check the next section.
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

Supported Data Types in CSV-based Decision Tables

DATA TYPE SUPPORTED OPERATORS
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
Text
Number
  • Equals
  • Not Equals
  • Less Than
  • Less or Equal
  • Greater Than
  • Greater or Equal
Boolean
  • Equals
  • Not Equals
  • 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.
 
Ladataan
Salesforce Help | Article