|Version 4 (modified by 17 years ago) ( diff ),|
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.
[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.