You are here:
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.
Required Editions
| Available in: Lightning Experience |
| Available in: Enterprise, Unlimited, and Developer Editions for clouds that have Business Rules Engine enabled |
Here are some examples of how the Does Not Match operator works for the data types that support the operator.
| Data Type | Description | EXAMPLE |
|---|---|---|
| Text | Retrieves an output if the query text isn’t an exact match or subset of the input cell text. The output is sorted by the sort order for the input columns that’s defined in the decision table. | A decision table column is configured like this:
The Department column has sales, presales, postsales, salessupport, support, and marketing as the row values. sales is passed as the input string for lookup. The table returns the output values for the input cells in ascending order starting with blank values, marketing, and support. Here, the query value isn’t an exact match or subset of the other input values. |
| Text | Retrieves an output if the query text isn’t an exact match or subset of the input cell text. The output is sorted by the sort order for the input columns that’s defined in the decision table. | A decision table column is configured like this:
The Job Title column includes the following row values: Senior Regional General Manager, General Manager, Regional General Manager, and Assistant General Manager. When Regional General Manager is passed as the input string for lookup with the Does Not Match operator, the table returns the output values for the non-matching input cells. The non-matching values are General Manager and Assistant General Manager. |
| Picklist | Retrieves an output if the query value isn’t an exact match or subset of the input cell value. Output sort order doesn’t apply to columns of the Picklist data type. |
A decision table column is configured like this:
The Status column has draft, inactive, active, draft, and not applicable as the row values. The Status column has inactive, active, draft, and not Applicable as the row values. The string active is passed as the query value to look up. The table returns the output values draft and not applicable since they aren’t an exact match or subset of the query. |
