It's all about the answers!

Ask a question

Reporting Test Cases and Last Execution Results from RQM

Bartosz Chrabski (3.3k12245) | asked Jul 31 '13, 7:54 p.m.
 Hi Team,

I am trying to create report which will show list of all project test cases with last result of execution for each one.

Of course I can find that in Execution->Test Cases (icon before name) but I need success or fail as separe column to sort that.

I am trying to use birt for that purpose and I need you suggestions which tabels and value should I use to make it working

Please HELP

4 answers

permanent link
Jun Wang (6077) | answered Jul 31 '13, 10:31 p.m.
RQM tracks execution status of TCER (test case execution record) not the test case, so it is hard to say the last status of a test case.

Since 4.0.1, some RQM OOTB execution related BIRT reports added a new parameter 'Most Recent Iteration Only' to give user a chance to show the last execution result of TCERs regardless different iteration (the test plan, test case and test environment are the same for those TCERs). It was implemented by javascript in data set. You may could refer to the report template to do the similar thing to show the last execution result of test case instead of last execution result of TCER. One referencing report is the report template 'Execution Status using TER Count.rptdesign'.

permanent link
Rajat Singh (59833543) | answered Aug 01 '13, 3:50 a.m.
edited Aug 01 '13, 3:52 a.m.

One simple way to generate a report for your tests would be to pull out a Test Execution Record report.
This can be achieved by simply browsing to your test plan that holds all your test cases.
Open the Test Case Execution Record section in this test plan.
This will list you all the Execution Records that are created for your test cases with its last result.

You may filter the TER's as per your requirement by selecting the options in the 'Last Result' dropdown:

Hope this helps!!

Best Regards

Bartosz Chrabski commented Aug 04 '13, 5:28 a.m.


Thanks for your response but it only solves problem for one test case and if I have 300 test case in my project only makes a lot of work. 

permanent link
Rajat Singh (59833543) | answered Aug 04 '13, 6:04 a.m.
Dear Bartosz

The filter would give you the results for all the test cases in your project area with respect to the 'Last Result' value.
For example, we have around 30000 test cases in our project area out of which 25000+ test cases are passed.
Once I select the last result criteria as passed, it would should me only those 25000 odd test case execution records with verdict as passed.

Similarly, I can select the last result as Failed, Not Run, etc and it would pull out the corresponding test case execution records.

You can also export this result to a spreadsheet to customize it further.

Hope this helps!!

Best Regards

Bartosz Chrabski commented Aug 04 '13, 6:16 a.m.

Dear Rajt,

I used your way but It did not show all Test Cases in Project, I see only 50 % 

Bartosz Chrabski commented Aug 04 '13, 6:18 a.m.

It is coused by lack of test execution record of all test cases but the customer would like to report those test cases too as not executed. 

Canberk Akduygu commented Sep 17 '14, 4:59 a.m.


We have a similar case. Our test team creates TCER while executing test cases. Whenever they want to report Test Case wihch are executed and not executed. They cant create this report.

I believe Test Case which are not run should be also reported as Not Run.

HP QC enables them to get reports bur we couldnt find a way to do that in RQM.

permanent link
Rajat Singh (59833543) | answered Aug 04 '13, 6:53 a.m.
Dear Bartosz

Since the report is pulled out from execution record front, its mandatory to have the execution records generated for all the test cases. Else like in your case, it you would display an incomplete report.

Since the same test case can be a part of multiple test plans, you would have to drill down at the test plan level and check if the test case linked to it has any TER created.
This can be done by adding the 'TER Count' category in the test case view under the test plan:

Best Regards

Bartosz Chrabski commented Aug 04 '13, 9:09 a.m.

 Dear Rajat,

The only case here it requires a lot of manual work, in case when you have 12 projects and each contains 120 test cases it will take some time to manage that.

Your answer

Register or to post your answer.