You are here:
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.
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 Matches operator works for the data types that support the operator.
| Data Type | Description | EXAMPLE |
|---|---|---|
| Text | Matches your input string to an entire value or a part of it in decision table cells and returns the output values of the rows that the cells belong to. 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 Applicant Code column has ABCDEXIJ, TMPUHBK, XYZABC, and NNABCOP as the row values. ABC is passed as the input string for lookup. The table returns the output values for the matching input cells in ascending order starting with blank values, followed by ABCDEXIJ, NNABCOP, and XYZABC. Here, ABCDEXIJ, XYZABC, and NNABCOP are considered as matching values because they contain the string ABC. |
| Text | Matches your input string to an entire value or a part of it in decision table cells and returns the output values of the rows that the cells belong to. 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 Matches operator, the table returns the output values for the matching input cells in ascending order, starting with blank values. The matching values are Regional General Manager and Senior Regional General Manager, as they contain the string "Regional General Manager." |
| AutoNumber | Matches your input number to an entire value or a part of a value in decision table cells and returns the output values of the rows that the cells belong to. 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 Serial Number column has 10, 100, 101, 102, 103, 111, and 120 as the row values. 10 is passed as the input value for lookup. The table returns the output values for the matching input rows in ascending order starting with blank values, followed by 10, 100, 101, 102, and 103. |
| Matches your input string to an entire email or a part of it in decision table cells and returns the output values for the rows that the cells belong to. 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 Contact Email column has rose@salesforce.com, lily@salesforce.com, jasmine@salesforce.com, salesforce.support@salesforce.com, lily@example.com, and rosa@example.com as the row values. The string, sales, is passed as the input value for lookup. The table returns the output values for the matching input rows in the order salesforce.support@salesforce.com, rose@salesforce.com, lily@salesforce.com, jasmine@salesforce.com, followed by output values for blank cells in the Contact Email column. |
|
| URL | Matches your input string to an entire URL or a part of it in decision table cells, and returns the output values for the rows that the cells belong to. 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 Company Website column has these row values:
The string, org, is passed as the input value for lookup. The table returns the output values for the matching input rows in this order starting with blank values: www.example.org/home and www.salesforce.org. |
| Picklist | Matches your input value to an entire value or a part of the value in decision table cells, and returns the output values for the rows that the cells belong to. 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, Active, Draft, and Not Applicable as the row values. The string, Dra, is passed as the input value for lookup. The table returns the output values for the rows whose Status column cells contain the term Dra and the rows where the cells in the Status column are blank. |
