DecisionTable

Represents the information about a decision table. This object is available in API version 51.0 and later.

Where possible, we changed noninclusive terms to align with our company value of Equality. We maintained certain terms to avoid any effect on customer implementations.

Note

Supported SOAP API Calls

create(), delete(), describeSObjects(), query(), retrieve(), update(), upsert()

Supported REST API Methods

DELETE, GET, HEAD, PATCH, POST, Query

Fields

Field Details
CollectOperator
Type
string
Properties
Defaulted on create, Filter, Group, Nillable, Restricted picklist, Sort
Description
For internal use only.
ConditionCriteria
Type
string
Properties
Filter, Group, Nillable, Sort
Description
Custom logic that's used to decide how the input fields are processed.
ConditionType
Type
picklist
Properties
Defaulted on create, Filter, Group, Nillable, Restricted picklist, Sort
Description
Condition logic that's used for input fields.
Possible values are:
  • All—All conditions are met (AND)
  • Any—Any condition is met (OR)
  • Custom—Custom Logic
The default value is 'All'.
DataSourceType
Type
picklist
Properties
Defaulted on create, Filter, Group, Nillable, Restricted picklist, Sort
Description
Type of data source that’s used to create a decision table. Available in API version 59.0 and later.
Valid values are:
  • MultipleSobjects—Multiple sObjects
  • SingleSobject—Single sObject
The default value is SingleSobject.
DecisionTableParameters
Type
QueryResult
Properties
Nillable
Description

Input or output field in a decision table.

DecisionTableSourceCriterias
Type
QueryResult
Properties
Nillable
Description
Filter criteria that’s associated with the decision table condition. Available in API version 59.0 and later.
Description
Type
textarea
Properties
Filter, Nillable, Sort
Description
Description of the decision table.
DeveloperName
Type
string
Properties
Filter, Group, Sort
Description
Developer name of the decision table.
DoesConsiderNullValue
Type
boolean
Properties
Defaulted on create, Filter, Group, Nillable, Sort
Description
Indicates whether a column that has a null value is considered for lookup (true) or not (false). The default value is false. Available in API version 60.0 and later.
FilterResultBy
Type
picklist
Properties
Filter, Group, Nillable, Restricted picklist, Sort
Description
If a collection of inputs returns multiple matching outputs, then the FilterResultBy field specifies how the results of a decision table are filtered.
Available in API version 59.0 and later.
Valid values are:
  • AnyValue—Any Value
  • FirstMatch—First Match
  • OutputOrder—Output Order
FullName
Type
string
Properties
Create, Group, Nillable
Description
Name of the decision table.
Query this field only if the query result contains no more than one record. Otherwise, an error is returned. If more than one record exists, use multiple queries to retrieve the records. This limit protects performance.
Language
Type
picklist
Properties
Defaulted on create, Filter, Group, Nillable, Restricted picklist, Sort
Description
Language in which the decision table is created.
Possible values are:
  • da—Danish
  • de—German
  • en_US—English
  • es—Spanish
  • es_MX—Spanish (Mexico)
  • fi—Finnish
  • fr—French
  • it—Italian
  • ja—Japanese
  • ko—Korean
  • nl_NL—Dutch
  • no—Norwegian
  • pt_BR—Portuguese (Brazil)
  • ru—Russian
  • sv—Swedish
  • th—Thai
  • zh_CN—Chinese (Simplified)
  • zh_TW—Chinese (Traditional)
LastSyncDate
Type
dateTime
Properties
Filter, Nillable, Sort
Description
Latest date on which the decision table was refreshed.
ManageableState
Type
ManageableState enumerated list
Properties
Filter, Group, Nillable, Restricted picklist, Sort
Description
Indicates the manageable state of the specified component that is contained in a package:
  • beta
  • deleted
  • deprecated
  • deprecatedEditable
  • installed
  • installedEditable
  • released
  • unmanaged
MasterLabel
Type
string
Properties
Filter, Group, Sort
Description
Label of the decision table.
Metadata
Type
complexvalue
Properties
Create, Nillable, Update
Description
Metadata of the decision table.
Query this field only if the query result contains no more than one record. Otherwise, an error is returned. If more than one record exists, use multiple queries to retrieve the records. This limit protects performance.
NamespacePrefix
Type
string
Properties
Filter, Group, Nillable, Sort
Description
Namespace prefix that’s associated with this object. Each Developer Edition org that creates a managed package has a unique namespace prefix. Limit: 15 characters. You can refer to a component in a managed package by using the namespacePrefix__componentName notation.

The namespace prefix can have one of the following values.

  • In Developer Edition orgs, NamespacePrefix is set to the namespace prefix of the org for all objects that support it, unless an object is in an installed managed package. In that case, the object has the namespace prefix of the installed managed package. This field’s value is the namespace prefix of the Developer Edition org of the package developer.
  • In orgs that aren’t Developer Edition orgs, NamespacePrefix is set only for objects that are part of an installed managed package. All other objects have no namespace prefix.
PricingElementDecisionTables
Type
QueryResult
Properties
Nillable
Description

Reserved for future use.

RefreshFailureReason
Type
string
Properties
Filter, Nillable, Sort
Description
Reason for the refresh of the decision table data to fail. Available in API version 60.0 and later.
RefreshStatus
Type
string
Properties
Filter, Group, Nillable, Restricted picklist, Sort
Description

Refresh status of the cached data in the decision table. Available in API version 60.0 and later.

Valid values are:

  • Initiated
  • Failed
  • Completed
  • In Progress
SetupName
Type
string
Properties
Filter, Group, Sort
Description
Required. Name of the decision table, which appears in Setup.
SourceConditionLogic
Type
string
Properties
Filter, Group, Nillable, Sort
Description
Condition logic that's used to define the decision table from the source data.
Available in API version 59.0 and later.
SourceObject
Type
string
Properties
Filter, Group, Nillable, Sort
Description
Required. Object that contains the rules based on which the decision table must provide outcomes.
Status
Type
picklist
Properties
Filter, Group, Restricted picklist, Sort
Description
Required. Status of the decision table.
Valid values are:
  • ActivationInProgress
  • Active
  • Draft
  • Inactive
Type
Type
picklist
Properties
Defaulted on create, Filter, Group, Nillable, Restricted picklist, Sort
Description
Determine whether a decision table’s data volume is high or low.
Available in API version 59.0 and later.
Valid values are:
  • HighVolume–Reserved for future use
  • LowVolume
  • HighScaleExecution

The default value is LowVolume.

UsageType
Type
picklist
Properties
Defaulted on create, Filter, Group, Nillable, Restricted picklist, Sort
Description

Usage type of the decision table.

Available in API version 59.0 and later.

Valid value is Bre. The default value is Bre.

When Business Rules Engine is enabled for a Salesforce org, the default value is Bre. Other usage types may be available to you depending on your industry solution and permission sets.