Extract test case results from Jazz RQM with RPE 1.1.2

Recently I had to generate some test cases reports from Jazz Quality Management with RPE 1.1.2. Everything went very smoothly until I also needed the testing results to be contained in my reports.

Here is the solution I came up with.

As you know, in RQM you have the possibility to assign an execution result to each test case. In this way, you can see which test cases passed and which of them failed. Also, a test case can have several results.

When you want to extract this information using RPE, you need to iterate feed/entry/content/testcase elements from the QM data source. For each test case, all the feed/entry/content/executionresult elements should be iterated

Each execution result element from the data source schema has a feed/entry/content/executionresult/testcase element. This element tells us to which test case this result belongs.  If we compare the attributes feed/entry/content/testcase/identified and feed/entry/content/executionresult/testcase/href, we can deduce whether the execution result belongs to the current test case or not. We will use a condition to display only those execution results belonging to the test case.

In order to iterate all the test cases, you must first add the QM data source schema and then add a Data Source Configuration Element to your template.

The URL for the collection data source schema is

https://host:port/jazz/service/com.ibm.rqm.integration.service.IIntegrationService/schema/feed.xsd

The target data source will be REST_qm.

The dynamic configuration URI will be:  https://giediprime:9445/qm/service/com.ibm.rqm.integration.service.IIntegrationService/resources/Web Publisher (Quality Management) /testcase?fields=feed/entry/content/testcase/*.

You also need to introduce your Jazz username and password in the Properties panel.

For each execution result we need to iterate through all feed/entry/content/executionresult elements. In order to do this, add a new data source to the template. Use the same URL for feed schema  and name the data source REST_executions_feed.

You need to insert one more Data Source Configuration element that will have as target the REST_execution_feed data source.  After that, set the URI of the configuration element.

This is how your final RPE template should look like:

The last column of the test cases table iterates all the execution results. In this column there is inserted another table, which has one entry for each execution result associated to the test case.

For each execution result, it must be verified if the execution result element corresponds to the current test case. If the condition is verified, the execution result is displayed.

The execution result state is contained by the   feed/entry/content/executionresult/state attribute.

This is how the generated document looks like: