RQM API: Get executionresult for executionworkitem
I'm trying to obtain a list of execution results for a specific testplan. I've successfully managed to get testcase for a given testplan, and then the execution records for a given testcase, but seem to have fallen at the last hurdle - I need the results for a specific TER. As I'm using version 3.0.1.2 I believe this is the way I need to get this data.
This is the URL I am requesting:
baseURL/projectName/executionresult?fields=feed/entry/content/executionresult/(identifier|executionworkitem[@href='baseURL/projectName/executionworkitem/urn:com.ibm.rqm:executionworkitem:43496'])
where baseURL = https://server:port/jazz/service/com.ibm.rqm.integration.service.IIntegrationService/resources
This returns all results. Perhaps someone can spot what I am doing wrong.
This is the URL I am requesting:
baseURL/projectName/executionresult?fields=feed/entry/content/executionresult/(identifier|executionworkitem[@href='baseURL/projectName/executionworkitem/urn:com.ibm.rqm:executionworkitem:43496'])
where baseURL = https://server:port/jazz/service/com.ibm.rqm.integration.service.IIntegrationService/resources
This returns all results. Perhaps someone can spot what I am doing wrong.
One answer
I don't think you're doing anything wrong and your syntax appears correct. I also could not get this to behave as expected in 3.0.1, but I could in 4.0.0.1. Defect 55129 (https://jazz.net/jazz02/web/projects/Rational%20Quality%20Manager#action=com.ibm.team.workitem.viewWorkItem&id=55129) indicates this should work in 3.0.1 so I have no explanation why you and I see different behavior.
FYI, if you can upgrade to 4.0, you can accomplish what you need in a single call, without traversing testplan->test case->execution record->execution result:
baseURL/projectName/executionresult?fields=feed/entry/content/executionresult/(*|testplan[@href='baseURL/projectName/testplan/urn:com.ibm.rqm:testplan:2'])
FYI, if you can upgrade to 4.0, you can accomplish what you need in a single call, without traversing testplan->test case->execution record->execution result:
baseURL/projectName/executionresult?fields=feed/entry/content/executionresult/(*|testplan[@href='baseURL/projectName/testplan/urn:com.ibm.rqm:testplan:2'])
Comments
Unfortunately, upgrade is not an option at this time. Thank you for confirming this works in a later version. I wonder if there is another way? Parsing 17k results might take too long.
Unfortunately, there is no other way to filter an executionresult feed based on a specific testplan.
Note, support for the testplan filter on the executionresult feed was added in RQM 4.0 (see footnote 4 of https://jazz.net/wiki/bin/view/Main/RqmApi#SupportedFieldsResources).