It's all about the answers!

Ask a question

How to pull Test Case data?


Jeffrey Burke (312637) | asked Sep 16 '14, 11:30 a.m.
Can data from Test Cases (such as the number of steps in a test case) be pulled so that it can be downloaded into an excel file?

Thanks!

One answer



permanent link
Ara Masrof (3.2k15) | answered Sep 16 '14, 4:08 p.m.
JAZZ DEVELOPER
 Gary,
One possible option would be to capture the XML of the artifact you are interested it then convert it to xls or csv format; this would require some level of parsing
You can using the REST API to return the Test Script data (Note: If you are interested in 'steps' you would need to reference the Test Script rather than the Test Case, for example (
GET
https://clm401:9443/qm/service/com.ibm.rqm.integration.service.IIntegrationService/resources/LPA+project+1+%28Quality+Management%29/testscript/urn:com.ibm.rqm:testscript:34

In this case my Public URI is "clm401:9443"
My QM Project is : LPA+project+1+%28Quality+Management%29
My Script ID is 34

You can use Poster (or any other HTTP client) to trigger the request. 

REST API reference https://jazz.net/wiki/bin/view/Main/RqmApi

Also, I found an RFE that seems very similar to what you are asking to do 
https://jazz.net/jazz02/web/projects/Rational%20Quality%20Manager#action=com.ibm.team.workitem.viewWorkItem&id=79508 

Hope this helps

Comments
Jeffrey Burke commented Sep 16 '14, 4:21 p.m.

Thanks Ara! What I was hoping for was a query, report or widget that could be ran (or automatically updated) so that management can keep an eye on the status on the number of steps and other values on an ongoing basis.

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.