It's all about the answers!

Ask a question

RPE - How to get ExecutionResults corresponding to TestCase from RQM


Prasun Roy (1674813) | asked Sep 28 '12, 12:32 p.m.
edited Sep 28 '12, 12:44 p.m.
 I am trying to generate a report from RPE that list all my TestCases and their corresponding ExecutionResults, found a good article at http://reportingarena.com/blog/extract-test-case-results-from-jazz-rqm-with-rpe-1-1-2/

But even after following all the steps I am unable to get the Results.

At the topmost level I added a Data Source Configuration element with Data Source pointing to Feed.xsd & dynamic URI of 
https://<rqm server>:9443/qm/service/com.ibm.rqm.integration.service.IIntegrationService/resources/<project name>/testcase?fields=feed/entry/content/testcase/*

then added one more Data Source Configuration element with a different Data Source pointing to Feed.xsd & dynamic URI of 
https://<rqm server>:9443/qm/service/com.ibm.rqm.integration.service.IIntegrationService/resources/<project name>/executionresult?fields=feed/entry/content/executionresult/testcase/*

also tried with 
https://<rqm server>:9443/qm/service/com.ibm.rqm.integration.service.IIntegrationService/resources/<project name>/executionresult?fields=feed/entry/content/testcase/*

but still not able to get the Results, the report only lists the TestCases.


Is there any other way to get the ExecutionResults. 

Accepted answer


permanent link
Robert Rassmann (9923) | answered Oct 02 '12, 2:34 p.m.
FORUM MODERATOR / JAZZ DEVELOPER
What you want to do is get a list of the executionResults filtered by the testcase.  For a single testcase it will look something like:

https://<server>:9443/qm/service/com.ibm.rqm.integration.service.IIntegrationService/resources/<projectAlias>/executionresult?fields=feed/entry/content/executionresult/(*|testcase[@href='https://<server>:9443/qm/service/com.ibm.rqm.integration.service.IIntegrationService/resources/<projectAlias>/testcase/urn:com.ibm.rqm:testcase:1'])

where urn:com.ibm.rqm:testcase:1 would be the ID if the testcase.

I'm not sure if the API supports filtering by multiple testcases (it may be worth trying), so you may have to iterate over the set of testcases that you want to report on.
Prasun Roy selected this answer as the correct answer

2 other answers



permanent link
Suraj Amasebail (1111) | answered Jul 16 '13, 3:04 p.m.
 I tried again with following URI and it worked for me. I could able to get the details of the result by this URI. Wanted to check if this is the right approach to get the results for a particular date and time. ( I got the exact date and time after running https://<SERVERNAME>/qm/service/com.ibm.rqm.integration.service.IIntegrationService/resources/<PROJECTNAME>/executionresult)

https://<SERVERNAME>/qm/service/com.ibm.rqm.integration.service.IIntegrationService/resources/<PROJECTNAME>/executionresult?fields=feed/entry/content/executionresult[updated='2013-02-18T21:42:03.628Z']


But if I wanted the list for the range of dates how can I achieve the same using REST APIs? What's the syntax for the https://<SERVERNAME>/qm/service/com.ibm.rqm.integration.service.IIntegrationService/resources/<PROJECTNAME>/executionresult?fields=feed/entry/content/executionresult[updated=<START DATE> TO <END DATE>] ?


permanent link
Suraj Amasebail (1111) | answered Jul 16 '13, 2:25 p.m.
 Hello,

We are trying to build a URL to get the test results updated after certain dates and while using the following URL we get error "Error 501: SRVE0295E: Error reported: 501". Any help is appreciated


https://<SERVER>/qm/service/com.ibm.rqm.integration.service.IIntegrationService/resources/<PROJECT>/executionresult[updated='2013-02-18T21:42:03.628Z']


Your answer


Register or to post your answer.