--- schema_version: "1" id: 51a4eb4359b102875631334915611aee0684ebd164cb0777fdb9c560de21307c title: Does Not Match Operator in Decision Tables collection: admin version: current locale: en-us portal_url: https://docs.salesforce.com/admin/current/en-us/ind/264-0-0/bre_doesnotmatch_operator_decision_table.md canonical_url: https://help.salesforce.com/s/articleView?id=ind.bre_doesnotmatch_operator_decision_table.htm&release=264.0.0&type=5 source_site: help.salesforce.com content_type: documentation content_hash: aae7e18dcfc8f161709391897f17a54233188698caaeb03e4f99f606b1266027 description: 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. products: - Industry Solutions - Cross Cloud release: "264" --- # 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: Column: Department Data Type: Text Operator: Does Not Match Sort Order: Ascending with Blank Values First 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: Column: Job Title Data Type: Text Operator: Does Not Match Sort Order: Ascending with Blank Values First 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: Column: Status Data Type: Picklist Operator: Does Not Match 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.

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:

Column: Department
Data Type: Text
Operator: Does Not Match
Sort Order: Ascending with Blank Values First

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:

Column: Job Title
Data Type: Text
Operator: Does Not Match
Sort Order: Ascending with Blank Values First

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:

Column: Status
Data Type: Picklist
Operator: Does Not Match

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.