Using a List of Values to Find Records in a Data Set
To determine if any value in a list of values appears in a column of business data, add the values on the list to a condition. The rule statement compares the values in the input that you select to the values in the list.
Add a list of values to a condition in the following scenario:
- •The business rule requirement that the condition represents applies to multiple values.
- •The organization does not maintain a reference table of the values.
For example, you might work for a manufacturing company that must recall a small number of products because of a product defect. You know the serial numbers of the products that you must recall. You configure a rule statement with an input that represents the column of serial number data. You add the list of serial numbers to recall to the rule statement condition.
1. Select a rule set in a rule specification.
2. In the rule set properties, click Rule Logic.
3. Click Add Rule Statement.
4. Select an input for the rule statement.
- - If the rule specification does not contain an input that you can use, create an input. Configure the input properties to represent the type of column that contains the business data.
5. Select an operator to validate the results of the condition analysis.
- - To identify input values that match the reference table values, select the following operator:
is within
6. Select the type of condition to apply to the input.
- - To enter a list of values, select the following condition type:
function
7. Configure the condition to apply a reference table to the input data.
- - Open the Define Condition dialog box.
- - Select Input, and select List of Values.
- - Enter a list of values. By default, the dialog box displays a single data field. Add a data field for each value on the list.
- - Click OK.
8. Select the type of action to apply to the data that satisfies the condition logic.
- - To return a string value, select the following action type:
string value
9. Enter the value that the action returns. For example, enter RECALL.
10. Save the rule specification.