Go to the latest v7.6 documentation →
Validation using Custom Business Rule
Using ‘Custom Business Rule’, the user can apply different conditions on different columns to meet the defined custom business rule. Let’s execute a validation scenario using ‘Custom Business Rule.’
To learn more, let us walk through the below procedure:
- Click the ‘SCENARIO STUDIO’ module.
- Hover on the ‘Scenario Builder’ snippet from the left pane options.
- Click the ‘Validation’ option.
Path: SCENARIO STUDIO > Scenario Builder > Validation
- The user is navigated to a new Validation session page in create and edit mode.
- From the ‘Data Source’ tab, let us drag and drop an ‘RDBMS Table’ icon onto the Validation session page.
- Double-tap the ‘Read data from Table’ widget.
- A ‘Read data from Table’ pop-up window is displayed.
- Let’s select Database Type as ‘PostgreSQL’ from the drop-down list.
- Select Connection Name as ‘PostgreSQL Northwind-QA’ from the drop-down list.
- Click the Navigator button.
- A ‘Navigator’ slide screen is displayed.
- Select and click the ‘orders’ table from the ‘Public’ schema.
- Click the ‘Select’ button.
- This action closes the ‘Read data from Table’ widget by saving its data.
- Click the ‘Validation Rules’ tab.
- Drag and drop the ‘Custom Business Rule’ icon onto the validation session page.
- Double tap the ‘Custom Business Rule’ widget.
- A ‘Custom Business Rule’ pop-up window is displayed.
- Add ‘Custom Business Rule’ within the ‘Rule Description’ text field.
Note: ‘Data Element’ is selected as default for the Validation Rule column(s)
- As a priority select the ‘Constant’ option and add ‘employeeid=3’ as the first business validation rule.
- Click the ‘+’ icon.
Note: A ‘+’ icon at the end is used to add a new business validation rule.
- This action adds a new business validation rule row.
Note: ‘AND’ drop-down selection enables to apply business validation rule for a different column and ‘OR’ applies business validation rule for the same column.
- Select ‘OR’ from the drop-down selection.
- As a priority select the ‘Constant’ option and add ‘employeeid=5’ as the second business validation rule.
Note: A ‘Delete’ icon at the extreme right is used to delete newly added business validation rule rows.
- The ‘Business Rule’ (employeeid EQUALS TO “3” OR employeeid EQUALS TO “5”) is updated accordingly.
- Click the ‘Save’ button.
- This action closes the ‘Special Character Check’ widget by saving its data.
- Click the ‘Additional Options’ tab.
- Drag and drop an ‘Email’ icon onto the Validation session page.
- Double-tap the ‘Email Settings’ widget.
- An ‘Email Settings’ pop-up window is displayed.
- Click the ‘Save’ button.
- This action closes the ‘Email Settings’ widget by saving its data.
- Click the ‘Execute Now’ button.
- A ‘Monitor mode’ is enabled.
- The validation scenario is ‘Failed’ here.
- Click on the ‘Special Character check’ widget count (661).
- The user is navigated to the ‘Validations Scenario Exceptions’ summary page.
- The user can also view the email validation results as shown here.