|Version 2 (modified by 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.
[ticket-custom] test_one = text test_one.label = Inverted Time
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.