Verify Data

This is prebuilt action in Avo Assure which is located under the @Generic element category. It instructs Avo Assure Client to verify Data from database table with input value andsubsequently store the status (True or False) in output variable.

Syntax

Input: <DB IP/instance name/DB file path>; <DB port>; <DB username>; <DB password>;<DB name>; <Query>; <DB Number>; <file path to verify data>; <Sheet Name>; <collection/ warehouse>(Optional); <querytype/schema>(Optional)

Output: <Dynamic Variable>;<Dynamic Variable>(Optional)

Use case/Example

Scenario:

Consider a scenario where user is testing an e-commerce application and needs to verify order data. For this scenario Verify Data action used by Avo Assure. when a customer places an order then user need to verify that the order data is correctly stored in the database. It helps to check the orders table for the correct order total and customer details and It confirms that the total of the items matches the order total in the orders table.

Expected Result

The Verify Data action needs to verify data from DB with input value.

Output

The Verify Data action performed and saves the status in the {Result} output variable as True