Zephyr Scale - Test Management for Jira
Zephyr Scale Overview
Zephyr Scale is a Jira test management solution with advanced test planning, reporting, and reusability features. This data is very important to be covered in Jira SQL reporting.
Zephyr Scale fields are located in a separate tab.
How to Add Zephyr Scale Token
Zephyr Scale Token is required to view and export the data.
Being signed in to your Jira Cloud instance, select your profile picture, and then select Zephyr Scale API Access Tokens.
Select the Create access token button.
The Access token successfully created pop-up window will appear.
Select the Copy button.
Select Close.
Go back to Apps, and then select SQL Connector for Jira.
On the left-side menu, select Tokens, and then select Zephyr Scale.
In the Token* field, paste your token, and then select Validate & Save.
Zephyr Scale Tables Filtering
SQL Connector for Jira Cloud offers the following filters:
by Projects: it can be applied to all exported tables
by TEST EXECUTIONS DATA RANGE: it can be applied to the Test Executions, Test Executions Issue Links, and Test Executions Custom Fields tables only
by TEST EXECUTIONS LAST ONLY: it can be applied to the Test Executions, Test Executions Issue Links, and Test Executions Custom Fields tables only
When you apply the filter by Projects, it will be applied to all selected tables automatically. If you want to export data from all projects for a specific table, you can uncheck the box in front of this table.
If you want to export test executions for a certain period, you have to select the data range by expanding the corresponding table. It will activate the TEST EXECUTIONS DATA RANGE.
If you apply the TEST EXECUTIONS LAST ONLY filter, the TEST EXECUTIONS DATE RANGE filter will be automatically disabled. Only one of these two filters can be selected at once.
For example, there are four test cases, but only three are included in the test cycle.
When you apply the TEST EXECUTIONS LAST ONLY filter, it means that the last execution of each of those three test cases and all executions of the one case outside the test cycle will be included in your exported data.