It's all about the answers!

Ask a question

Jazz Report Builder: Aggregate functions based most recent test results linked to test cases (reported by)


Pierre Hofrichter (11) | asked Nov 30 '22, 3:20 a.m.

 Hello,

i want to do a traceability analysis of the test coverage for requirements. Each test case might have multiple test execution records and thus multiple test results. For me only the most recent test results is important (max value of last update or test result ID).

The relationship is:
Requirements Document (uses) -> Requirement (validated by) -> Test Cases (Reported by) -> Test Result 

The output is the following (example):
  1. ReqDoc1 -> Req1 -> TestCase 1 -> TestResult1 (most recent)
  2. ReqDoc1 -> Req1 -> TestCase 1 -> TestResult2
  3. ReqDoc1 -> Req1 -> TestCase 2 -> TestResult3 
  4. ReqDoc1 -> Req1 -> TestCase 2 -> TestResult4 (most recent)
  5. ...
I want to perform some aggregate functions to generate some metrics. But before i need somehow filter the most recent.My idea was the following:
  1. Filter most recent (i don´t know how to do)
  2. perform IF and SUM over test results grouped by test case 

2 answers



permanent link
David Honey (1.8k17) | answered Nov 30 '22, 5:59 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

Currently, I think only a QM Test Execution Record has a link to the current test case result. So you might try something like:


permanent link
Pierre Hofrichter (11) | answered Nov 30 '22, 6:52 a.m.

 This approach i was also thinking about but each teach case might have multiple test executions records. How i know which test execution contains the most recent test result?

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.