Run Query

This is prebuilt action in Avo Assure which is located under the @ Generic element category. It instructs Avo Assure Client to run query executes the specified query on the database provided in the input value.

Syntax

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

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

Use case/Example

Scenario

Consider a scenario where the user is testing an application and needs to run a query in the database to retrieve all orders for a specific product from the last month. For this scenario Run Query action used by Avo Assure. The user specifies the product ID and date range, and the application executes the query to find matching orders. The query returns order details such as order IDs, customer names, and status, allowing the team to quickly review and manage the relevant orders.

Expected Result

The Run Query action needs to run query on specified DB from input value.

Output

The Run Query action performed on specified DB and executes query.