Forum Discussion

DannyT23's avatar
DannyT23
New Contributor
5 years ago
Solved

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

Any suggestions?

Thanks

  •  
  • melgage's avatar
    melgage
    2 years ago

    Greg,

     

    You can accomplish this using Databanks. Databanks allow you to map information to specific actions and inputs in your scripts. They can be configured to allow for Random, Sequential, and Unique options for reading data from the attached comma-, or tab-deliminted file. For your case, you would want to employ the Unique option as detailed in the documentation.

     

    Data Driving with LoadNinja Databanks 

     

    Here's a sample of a file I use for my demonstrations, with user and pass columns. For Unique data, you'll need at least as many rows as you have virtual users in your load scenario.

     

     

     

    Cheers,

    Mel

1 Reply

Sort By
  • MisterB's avatar
    MisterB
    Icon for Champion Level 3 rankChampion Level 3
    4 years ago
    Copy Link

    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