After setting up WHERE and HAVING conditions , you can view a summary of the rule or data source and make any changes. The system automatically creates a Rule ID or Data Source ID.
- [Optional] From Rule summary or Data Source summary, enter a Description.
To verify and add values to rule settings or data source settings:
Tab Description Variables To create a variable, select Creat Variable and complete the fields.
To modify a variable, selectand enter a new value.
To delete a variable, select Delete to confirm., then
Formulas To modify a formula, select, then select new fields, functions, or variables.
To delete a formula, select Delete to confirm., then
SQL Select Generate SQL to view the SQL. Explain
- Select Generate SQL from the SQL tab.
- Select Explain SQL to view the EXPLAIN plan provided by the database.
- Select Save.