Forum Discussion

chad84's avatar
chad84
New Contributor
4 years ago

Looking for a macros for test case status

Looking for a macros for test case status on a singular level. We use a table to keep track of test case development and having to enter this data manually gets tedious.   I'm looking for somethin...
  • MisterB's avatar
    MisterB
    4 years ago

    Hi,

     

    I'm not sure but you might be able to manage and report this within Zephyr Scale by changing the test case version number or by using labels, in combination with the test case status which you can customise and add extra statuses.  The Test Library > Test cases (summary) Report might provide the information you need but if not...

     

    Run one of the test execution reports and use the export to Excel dataset option (top right-hand corner).  That will produce a file with details that includes the test case status, version number, and a whole lot more.  Dump that data into a working sheet and wrap it into a table.  From there it should be simple to add another 'report' sheet in Excel, with formulas, that will look at the table you just created.  If you save the URL of the report you can re-run it anytime you need and repeat the data dump process above to 'refresh' your table.

     

    Best, Andy 

     

     

MisterB's avatar
MisterB
Champion Level 3
4 years ago

Hi,

 

I'm not sure but you might be able to manage and report this within Zephyr Scale by changing the test case version number or by using labels, in combination with the test case status which you can customise and add extra statuses.  The Test Library > Test cases (summary) Report might provide the information you need but if not...

 

Run one of the test execution reports and use the export to Excel dataset option (top right-hand corner).  That will produce a file with details that includes the test case status, version number, and a whole lot more.  Dump that data into a working sheet and wrap it into a table.  From there it should be simple to add another 'report' sheet in Excel, with formulas, that will look at the table you just created.  If you save the URL of the report you can re-run it anytime you need and repeat the data dump process above to 'refresh' your table.

 

Best, Andy 

 

 

  • sonya_m's avatar
    sonya_m
    SmartBear Alumni (Retired)
    4 years ago

    Thanks a lot for your reply MisterB !

     

     

    Hi chad84! Does this suggestion help? 

    • chad84's avatar
      chad84
      New Contributor
      4 years ago

      Yes sonya_m , thanks MisterB I'll give these suggestions a try, thanks 🙂