UI How to Access Test Data Queries (or G-Queries) and create a G-Query
In this lesson, you will learn how to access the G-Queries Management Dashboard and create a Test Data Query or G-Query.
How to Access Test Data Queries or G-Queries
- Select a Project within the Project Dashboard.
- Expand the Self Serve Options Menu within the Project Versions Pane and select G-Queries.
G-Queries Management Dashboard (or Platform)
The G-Queries Management Dashboard can be used to view and manage each Test Data Query for a selected Project Version within a given Project.
Within this dashboard, you can create and manage Test Data Queries or G-Queries. Below is an image of a Database Test Data Query that we will be showing how to configure within this training module.
Six Types of Queries
GenRocket Test Data Queries provides six types of query options:
- Query Before – Query columns from one or more database tables as a set of data that is buffered into memory.
- Query Each – Query one row of columns, from one or more database tables, on each row iteration of test data generation.
- CSV List – From a CSV file, pull rows of data having one or more columns, into memory as a list of data.
- CSV Index – From a CSV file, pull rows of data having one or more columns, into memory and retrieve any row via its row index.
- Mongo Before – Query columns from one or more database collections as a set of data that is buffered into memory. This is the same as Query Before but designed specifically for use with Mongo.
- Mongo Each – Query one row of columns, from one or more database collections, on each row iteration of test data generation. This is the same as Query Each but designed specifically for use with Mongo.
How to Create a Test Data Query
Click on the Add G-Query button within the G-Queries Management Dashboard.
Give your Test Data Query a unique Name and Description.
Select the type of Query you want to define: Query Before, Query Each, CSV List, CSV Index, Mongo Before, or Mongo Each.
Then click the Save button.
Once a G-Query has been created, you will be able to configure its Parameters, add a Query or import a CSV file, and add Domains/Attributes.
Please continue to the next lesson to learn how to configure a Database Test Data Query.