Test plan report that lists failed Test Cases along with their defect Tickets

[anonymous]

Is it possible to have a Tes Plan Report that lists all the failed Test Cases along with their defect Tickets?

This woulld be a really useful Project report.

[seccanj]

Hi,
this is an interesting enhancement to nake.

In the meantime, you could also try a simple report as follows, which is not elegant but should provide you with the desired info.

Go to "View Tickets", then "Create new Report", and paste the following into the "Query for Report" field.

select 
tcip.planid as "Test plan ID",
tp.name as "Test Plan Name",
tcip.page_name as "Test Case",
rtrim(substr(w.text,3,50), '=' || X'0A' || X'0D') as "Test Case Title",
tcip.status as "Test Case Status",
t.id as ticket,
t.summary as "Ticket Summary",
t.status as "Ticket Status",
t.owner as "Ticket Owner",
t.time
from testcaseinplan as tcip
left outer join ticket_custom as tcus, ticket as t
on tcus.name = 'planid' and tcus.value = tcip.planid 
and tcus.ticket = t.id 
and t.description like '%' || tcip.page_name || '%'
left outer join wiki as w
on w.name = tcip.page_name
left outer join testplan as tp
on tcip.planid = tp.id

Let me know how it goes.

Ciao,
Roberto