Page History
...
This report lists some details of the selected Test Executions in Xray, enabling it them to be extracted in an Excel format. With this ability to extract the report you can use it for analysis of trends , and current testing status, or process this information to generate some metrics, for example, or even share it with someone else who doesn't have still needs access to Jira.
Possible usage scenarios:
...
The following table shows an example of the columns/rows you should expect.
How to use
This report can be generated from different places/contexts, including:
- Issue view screen
- Issue search page (main search page or as a bulk operation)
Info | ||
---|---|---|
| ||
General information about all the existing places available to export from , and how to perform it , is available in on the Exporting page. |
Source data
...
The standard output format is .XLSX , so you can open it in Microsoft Excel, Google Sheets, and other tools compatible with this format. From those tools, you may be able to can generate a .CSV file.
Report assumptions
...
This sheet will present a line per each Test Execution.
Column | Notes |
---|---|
Key | Issue key of the Test Execution |
Summary | Summary of the Test Execution |
Fix versions | Fix version(s) defined in the Test Execution |
Revision | Revision defined in the Test Execution |
Begin Date | Timestamp of when the Test Execution started, in the format "dd-MM-yyyy hh:mm:ss" |
End Date | Timestamp of when the Test Execution ended, in the format "dd-MM-yyyy hh:mm:ss" |
Test Environment | Test Environment(s) defined in the Test Execution |
Test Plan | Test Plan(s) linked to the Test Execution |
Defects | Defects linked to the Test Execution (at either the test run or the test step level) |
Elapsed Time | Sum of elapsed time of all associated test runs in HH:MM:SS format. Please note that it will output "00:00:00" when there are no tests associated with the execution (or your executions are really fast) and " " when there are tests in progress (i.e. "Executing" or "To Do" status). |
#Test Runs | Number of test runs that are part of the Test Execution. |
Passed | Number of runs in the passed status. |
Passed (%) | Percentage of runs in the passed status. |
Failed | Number of runs in the failed status. |
Failed (%) | Percentage of runs in the failed status. |
Executing | Number of runs in the executing status. |
Executing (%) | Percentage of runs in the executing status. |
To do | Number of runs in the to do status. |
To do (%) | Percentage of runs in the to do status. |
Aborted | Number of runs in the aborted status. |
Aborted (%) | Percentage of runs in the aborted status. |
Customizing the report
The common customization actions are:
...
- Copy the "Summary" column
- Insert the copied content in a column next to the “Fix Versions”
- Change the header of the column to be “Description”
- Change the cell content from ${Summary} to ${Description}
- Save the template and upload it
As this report is column-based, if some columns are not relevant to you, you should be able to simply delete them. Make sure that no temporary variables are created in the cells of those columns that are used in other subsequent columns.
...