Report whith CustomFields

This is a simple Custom Repor with Custom Ticktes Fields.

A report show a Milestone sumarize time inverted, new field test_one is Time to resovle 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.