It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×12,008
×10,962

question asked: Jan 04 '19, 4:47 a.m.
question was seen: 2,452 times
last updated: Jan 09 '19, 10:44 p.m.

Related questions

RQM Report Builder - Current Test Result

0
Jörg Werner (303●38●81) | 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

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Krupa Gunhalkar (451●2) | 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
0
permanent link
Krupa Gunhalkar (451●2) | 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.


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.