After setting up WHERE and HAVING conditions , you can view a summary of the rule and make any changes. The system automatically creates a Rule ID.
- [Optional] From Rule summary, enter a Description.
-
To verify and add values to rule settings:
Tab Description VARIABLES View the rule variable.
To create a variable, click CREATE VARIABLE and complete the fields.
To modify a variable, select
> Edit and enter a new value.To delete a variable, select
> Delete, then DELETE to confirm.FORMULAS View the formula.
To modify a formula, select
> Edit, then select new fields, functions, or variables.To delete a formula, select
> Delete, then DELETE to confirm.SQL View the SQL.
Click GENERATE SQL to view the SQL.
EXPLAIN View the Explain SQL.
- Click GENERATE SQL from the SQL tab.
- Click EXPLAIN SQL to view the EXPLAIN plan provided by the database.
- Click SAVE.