Forum Discussion

DannyT23's avatar
DannyT23
New Contributor
4 years ago

ZephyrScale | Server | Traceability Report

Hello Team! I'm searching for a simple way to export (report) a list showing the hierarchies between "Test Plans & Test Cycles": TP-1 Name TC-1 Name TC-2 Name TP-2 Name TC-3 Name TC-4 Name ...
Test Results
  • MisterB's avatar
    MisterB
    4 years ago

    Hi Danny,

     

    I've not found a way to do this with the reports or by export because Test Plan data is not included in the Excel dataset extract - a gap that I hope the smartbear development team will fix in the future.

     

    It is however possible to get at the data you need using the API but it will require a bit of work on your part to setup the data conversion in Excel as the raw data comes in a JSON format and needs to go through Power Query.  Hopefully you know how to do that or have someone technical that can help but let me know if not.

     

    The URL you need to use is below - the red text you'd need to replace including removing the square brackets.  Below that, I've added an example of how it could look (note: the white spaces after "projectKey" are required)

     

    https://[YOUR JIRA INSTANCE]/rest/atm/1.0/testplan/search?query=projectKey = "[YOUR PROJECT KEY]"

     

    https://jira.abclimited.com/rest/atm/1.0/testplan/search?query=projectKey = "Project1"

     

    Hope it helps.

     

    Andy

MisterB's avatar
MisterB
Champion Level 3
4 years ago

Hi Danny,

 

I've not found a way to do this with the reports or by export because Test Plan data is not included in the Excel dataset extract - a gap that I hope the smartbear development team will fix in the future.

 

It is however possible to get at the data you need using the API but it will require a bit of work on your part to setup the data conversion in Excel as the raw data comes in a JSON format and needs to go through Power Query.  Hopefully you know how to do that or have someone technical that can help but let me know if not.

 

The URL you need to use is below - the red text you'd need to replace including removing the square brackets.  Below that, I've added an example of how it could look (note: the white spaces after "projectKey" are required)

 

https://[YOUR JIRA INSTANCE]/rest/atm/1.0/testplan/search?query=projectKey = "[YOUR PROJECT KEY]"

 

https://jira.abclimited.com/rest/atm/1.0/testplan/search?query=projectKey = "Project1"

 

Hope it helps.

 

Andy