How can I get the latest Test Case Result ID and Verdict using Jazz Report Builder
Hello everyone,
I am using Jazz Report Builder to get the complete traceability starting from requirements to test case and test case result ID and Verdict.
I have created the following traceability relation, and I am interested to get the latest test case result ID and Verdict.
In the format results section, I have used Custom Expression to get the MAXIMUM Value of Test Result ID and Verdict as shown below.
I have created the following traceability relation, and I am interested to get the latest test case result ID and Verdict.
In the format results section, I have used Custom Expression to get the MAXIMUM Value of Test Result ID and Verdict as shown below.
MAX($QM Test Result:Id$)
MAX($QM Test Result:Verdict$)
By using this method, it provides the latest Test Result ID from the latest execution record, but the verdict does not match with some of the test result IDs. There is a discrepancy between the latest Result ID and Verdict.
Does anyone knows the way to get the latest Test Result ID and Verdict? Please let me know if you have any suggestions on this.
Thanks in advance!
BR,
Anjuri
3 answers
Don't do it this way. It may not always work due to edge cases and users being users.
DO QM Test Execution Record -> QM Test Result -> Current Test Case Result
This will always get the last execution result.
The JRS devs did the heavy lifting here, let's leverage it! Good luck!
Kevin Murphy
IBM Champion
Hello Kevin,
Thanks for your answer but the issue with this method that I am facing here is following:
If one test case has 5 test execution records, the report will display the current result for all 5 of the test execution record.
In my case, I am only looking for the latest execution record and latest test case result verdict.
do you know if it's possible? I can try to add custom expression to get the maximum of the test execution record, but as soon as I add other attributes such as result ID and verdict, the result is not exact.
Please let me know if you have any idea for this situation.
Thanks,
Anjuri
This is an interesting limitation of report builder.
I want to say so bad that your use case goes against the design of how the tools should be used...
HOWEVER the tool itself does just that!
If I have a test case linked to a requirement, and that test case has 5 TCERs, when I am in DOORS Next I can see the icon of the test case and the icon of the TC shows the last verdict.
I could not find a simple way to do this in 7.0.2.
You likely saw this article:
It kind of works in 7.0.2 but not really. The issue I found is that if you don't include the verdict column, it comes out with exactly what you want every time (except the verdict, which is the most important thing).
But when you include the verdict, you get the last result for each verdict.
Step 8 in the link above does not work in 7.0.2.
This may be a good question to ask support. I am wondering if using SQL in 7.1 will make this easier.
If you must make this work now, I would look up the limit keyword in sparql. I don't recommend this though, as when you are forced to convert your reports to SQL this one won't be handled.
The other thing you can do is to do a report for each verdict -- so last passed, last failed, etc.
Wish I could assist further. Good luck.
Kevin Murphy
IBM Champion