Opened 12 years ago

Closed 12 years ago

#9914 closed enhancement (fixed)

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

Reported by: anonymous Owned by: Roberto Longobardi
Priority: normal Component: TestManagerForTracPlugin
Severity: normal Keywords:
Cc: Trac Release: 0.11


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.

Attachments (0)

Change History (2)

comment:1 Changed 12 years ago by Roberto Longobardi

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.

tcip.planid as "Test plan ID", 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", as ticket,
t.summary as "Ticket Summary",
t.status as "Ticket Status",
t.owner as "Ticket Owner",
from testcaseinplan as tcip
left outer join ticket_custom as tcus, ticket as t
on = 'planid' and tcus.value = tcip.planid 
and tcus.ticket = 
and t.description like '%' || tcip.page_name || '%'
left outer join wiki as w
on = tcip.page_name
left outer join testplan as tp
on tcip.planid =

Let me know how it goes.

Ciao, Roberto

comment:2 Changed 12 years ago by Roberto Longobardi

Resolution: fixed
Status: newclosed

Modify Ticket

Change Properties
Set your email in Preferences
as closed The owner will remain Roberto Longobardi.
The resolution will be deleted. Next status will be 'reopened'.

Add Comment

E-mail address and name can be saved in the Preferences.

Note: See TracTickets for help on using tickets.