Edgewall Software

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

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.

Note: See TracWiki for help on using the wiki.