3.2.3 Variables

Abbreviations, used in manual:

QG - Quality Gates

Variables are used to store values for reuse within QG processes. In QG module Scripts are available in the left side menu, under each specific  "Project -> Library -> Variable" section:

All variables defined for the selected project will appear in the grid:

Available operations in the Variables grid:

Bulk Operations - allow to mark a few Variables at a time and to Delete or Copy them together.

Deploy/Deploy All - allows to Deploy selected Variables/all the Variables in the page from one environment to another.

A Variable(s) can also be Edited/Copied/Deleted by clicking relevant icons in each row.

 

In order to create new Variable, click "Add Variable" button:

Name - choose suitable name for Variable.

Description - short and informative Variable description.

Tags - Variable can be related to appropriate Tag(s).

Data Type - choose variable data type from the list of available values:

Use in monitor - relevant Variable's value will be shown in the Full Monitor dashboard for specific execution(s).

Part of the execution key -  will be added as part of the key as a unique value.

Variable Type - there are 2 available types:

• Fixed value – assigning a fixed value to a Variable enables to manage “hard coded” values in one central place. If you choose this Variable type, you will be asked to insert the Variable value:
• Single value from query – Variable's value is returned as result of an SQL query (for RDBMS Data Sources only):

Null default value - value that will be returned from Variable if SQL query returns nothing.

The calculated query variable is based on abilities similar to an RDBMS Data Set. It means that the SQL query can be created in the query builder or by free command. For detailed manual please see RDBMS Data Sets

There are 3 options to define the returning value:

• Restrict to one column – if SQL query returns several rows and/or columns, it will use data from the first value returned (first column, first row).
• Concatenate fields into one field using , separator – if the query returns several columns, values will be concatenated into a single value using comma separator.
• When more than one value is returned, concatenate to create an in list value using , separator – if SQL query returns several rows, they will be concatenated into a single value using comma separator.

Variables can be combined in different processes/places: several Variables can be used in Data Set query and the same variable(s) can also be used in another place in the same Test/Execution Flow or in other Tests/Execution Flow. The Variables can be fetched as dynamic query, dynamic threshold in Test(s) and as a value in Script(s).