RPE - How to get ExecutionResults corresponding to TestCase from RQM
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
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.
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.
2 other answers
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']
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>] ?