Page History
| Table of Contents |
|---|
Purpose
This report lists some details of the selected Test Plans in Xray, enabling it them to be extracted in an excel 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 that hasn't still needs access to Jira.
Possible usage scenarios:
- see all
- the Test Run Status
- overall status for a given Test Plan see the status of Test Runs in a Test Plan and understand what happened
- , considering the consolidated results for the Tests being tracked
- track the planned Test Plans that are taking most time
- for a release
Output Example(s)
The following table shows an example of the columns/rows you should expect.
In more depth...
| Key | Summary | Fix Versions | Begin Date | End Date |
|---|
| #Test | Passed | Passed (%) | Failed | Failed (%) | Executing | Executing (%) | To do | To do (%) | Aborted | Aborted (%) | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| EWB-705 | CC Test Plan v1.2 | 1.2 | 17-11-2023 02:30:00 | 13-11-2023 03:00:00 |
Total Tests: 3
PASSED: 1 | 33%FAILED: 1 | 33%
EXECUTING: 1 | 33%
TO DO: 0 | 0%
ABORTED: 0 | 0%
18 | 1 | 5.6 | 5 | 27.8 | 2 | 11.1 | 8 | 44.4 | 2 | 11.1 |
| EWB-607 | Demo Test Plan |
2 |
FAILED: 0 | 0%
EXECUTING: 0 | 0%
TO DO: 0 | 0%
ABORTED: 0 | 0%
2 | 100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||
| ... |
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 theon the Exporting pagepage. |
Source data
This report is applicable to:
...
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
...
| Code Block | ||
|---|---|---|
| ||
project = "EWB" and issuetype = "Test Plan" order BY created DESC |
...
| Code Block | ||
|---|---|---|
| ||
project = "EWB" and issuetype = "Test Plan" and fixVersion=1.2 order BY created DESC |
...
| Code Block | ||
|---|---|---|
| ||
project = "EWB" and issuetype = "Test Plan" and testEnvironments = chrome order BY created DESC |
...
This sheet will present a line per each Test Plan.
| Column | Notes |
|---|---|
Key | Issue key of the Test Plan |
| Summary | Summary of the Test Plan |
| Fix versions | The fix versions defined in the Test Plan |
| Begin Date | Timestamp of when the Test Plan started, in the format "dd-MM-yyyy hh:mm:ss" |
| End Date | Timestamp of when the Test Plan ended, in the format "dd-MM-yyyy hh:mm:ss" |
| #Tests | Number of tests that are part of the Test Plan |
|---|
. | |
| Passed | Number of Tests in the passed status. |
|---|---|
| Passed (%) | Percentage of Tests in the passed status. |
| Failed | Number of Tests in the failed status. |
| Failed (%) | Percentage of Tests in the failed status. |
| Executing | Number of Tests in the executing status. |
| Executing (%) | Percentage of Tests in the executing status. |
| To do | Number of Tests in the to do status. |
| To do (%) | Percentage of Tests in the to do status. |
| Aborted | Number of Tests in the aborted status. |
| Aborted (%) | Percentage of Tests in the aborted status. |
Customizing the report
Adding or removing information to/from the report
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.
To add additional information, usually we're usually thinking of adding:
- fields of the Test Plan itself
Exercise: add a field from the related Test Plan issue
...
- Copy the "Summary" column
- Insert the copied content in a column next to the “Test Run Status”“Summary”
- Change the header of the column to be “Description”
- Change the cell content from ${Summary} to ${Description}
- Save the template and upload it
...
| Info | ||
|---|---|---|
| ||
|
Known limitations
...