It's all about the answers!

Ask a question

RQM Report Builder - Current Test Result


Jörg Werner (3033374) | asked Jan 04 '19, 4:47 a.m.
Hello,

I would like to create a report of all test results where the current/latest test result is "ERROR".
Within RQM it is possible to browse and filter by column 'Current'

With Report builder I do now know how to define a query.
Is this use case possible with Report Builder?
In case there is no attribute "Current" may be it can be done with  a relationship?

 thanks and happy new year to all off you, Jörg



2 answers



permanent link
Krupa Gunhalkar (4362) | answered Jan 06 '19, 9:55 p.m.
JAZZ DEVELOPER

Hi Jörg Werner,

As of now, there is no option available for the end user to select the "Current" state of the Test Case Result in Report Builder. Please raise it as an enhancement if needed absolutely for your team. Simplest way would be to just provide it as one of the Attribute fields.

Thanks and Regards,
Krupa Gunhalkar



Comments
Jörg Werner commented Jan 09 '19, 8:50 a.m.
thanks Krupa!

If there is no direct solution, then may be an "advanced" solution with SQL?

I'm sure that this is possible, but I don't know the syntax.

Select A.* from testcaseresult A
   where A.id  = (select max(B.id) from testcaseresult B where B.id = A.id)
Hope this shows at least the general idea :-)

  Thnaks, Jörg

permanent link
Krupa Gunhalkar (4362) | answered Jan 09 '19, 10:44 p.m.
JAZZ DEVELOPER

Hi Jorg,

This is a property that we don’t expose to LQE . We don’t have a SPARQL to retrieve this  currently . Maybe it is not impossible but currently its not supported. Request you to create an enhancement for the same.


Thanks and Regards,

Krupa Gunhalkar

Your answer


Register or to post your answer.