Query

Add Query write Queries on different Databases without much needed additional system files and code to execute the query

What is Query in QATTS?

Add Query write Queries on different Databases without much needed additional system files and code to execute the query. Its functionality is to execute the SQL queries on the Database. Normally, if you want to execute a query on the database you have to install a Database tool to perform the tasks. such as installing a Database as Oracle Db or MySQL.

Step by step walkthrough

To add Query follow the below steps.

STEP 1: Click on Studio on the Left Navigation Panel, it directs to new window which will be appearing as shown below.

A new window is opened after clicking on the Studio

STEP 2: On the right corner Click on "+" icon and select Add Query, it should appear as below.

STEP 3: Fill the required details as shown in the below screenshot.

• Query Name: The name could be any of the user choice.

• Description: Describe the action of the query.

• Alias Name:

• Query: Here user can write the query, it could be of any depending on the requirement.

STEP 4: After adding the required details click on Save and the data will be added in the Group you have Selected.

Short Video