cancel
Showing results for 
Search instead for 
Did you mean: 

Looking for a macros for test case status

SOLVED
chad84
New Contributor

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 something that can get the status of a test case and add it do a cell within a table. Is this possible?

I've posted a screenshot of what I'm after... the status 'Draft' will be updated each time the test case is updated.

 

chad84_0-1617257474404.png

 

Regards

1 ACCEPTED SOLUTION

Accepted Solutions
MisterB
Occasional Contributor

Re: Looking for a macros for test case status

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 

 

 

View solution in original post

3 REPLIES 3
MisterB
Occasional Contributor

Re: Looking for a macros for test case status

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 

 

 

View solution in original post

sonya_m
Community Manager

Re: Looking for a macros for test case status

Thanks a lot for your reply @MisterB !

 

 

Hi @chad84! Does this suggestion help? 


Sonya Mihaljova
Community and Education Specialist

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️
chad84
New Contributor

Re: Looking for a macros for test case status

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

New Here?
Join us and watch the welcome video:
Top Kudoed Authors