Using a Query Rule in Workflow

This configuration of the Run Rule activity allows you to use a query to find specific data in lookup table or external data source.

To use a query rule in a workflow:

1. Drag the Run Rule activity from the toolbox pane and drop it in the Designer pane.
2. In the properties pane, type a name and description of the activity.
3. In the Rule property box, select whether you want to run a Data Query or Lookup Table Query.
4. Select the rule and rule version.
5. Under Input Values, specify the token or hard-coded values you want to use for each input field. The input values presented here correspond to the Input Value column in the WHERE section of the data query, when the input value is set as an input parameter.
6. Under Output Tokens, specify the name and tag of the single-value token that contains the result of the rule. The output values presented here correspond to the Output Parameter column in the SELECT section of the data query.
7. Click Test rule to preview the output.
8. Under Rows to Return, specify the number of results to return when more than one row matches the inputs. This is especially useful when a data query finds all rows in a table of 10,000 rows, but you only want the first three rows.