Opened 4 years ago

Closed 4 years ago

#9914 closed enhancement (fixed)

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

Reported by: anonymous Owned by: seccanj
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 4 years ago by 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.

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 4 years ago by seccanj

  • Resolution set to fixed
  • Status changed from new to closed

Add Comment

Modify Ticket

as closed The owner will remain seccanj.
The resolution will be deleted. Next status will be 'reopened'.

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

Note: See TracTickets for help on using tickets.