Edgewall Software

Version 4 (modified by anonymous, 17 years ago) ( diff )

minor spelling mods

Report with CustomFields

This is a simple Custom Report with Custom Ticktes Fields.

A report to show a Milestone summarize time inverted, new field test_one is Time to resolve a Ticket.

Enjoy!

Trac.ini

[ticket-custom]
test_one = text
test_one.label = Inverted Time

Custom SQL

SELECT 
   milestone as Proyectos,
   sum(p.value) as Tiempo_Invertido
   FROM ticket t, ticket_custom p
   WHERE p.ticket = t.id and p.name = 'test_one'
   group by milestone
   ORDER BY milestone

BTW.Sorry my English and short text.

Note: See TracWiki for help on using the wiki.