| 1 | '''Report whith CustomFields''' |
| 2 | |
| 3 | This es a simple Custom Repor with Custom Ticktes Fields. |
| 4 | |
| 5 | A report show a Milestone sumarize time inverted, new field test_one is Time to resovle a Ticket. |
| 6 | |
| 7 | Enjoy! |
| 8 | |
| 9 | Trac.ini |
| 10 | {{{ |
| 11 | |
| 12 | [ticket-custom] |
| 13 | test_one = text |
| 14 | test_one.label = Inverted Time |
| 15 | |
| 16 | }}} |
| 17 | |
| 18 | Custom SQL |
| 19 | {{{ |
| 20 | SELECT |
| 21 | milestone as Proyectos, |
| 22 | sum(p.value) as Tiempo_Invertido |
| 23 | FROM ticket t, ticket_custom p |
| 24 | WHERE p.ticket = t.id and p.name = 'test_one' |
| 25 | group by milestone |
| 26 | ORDER BY milestone |
| 27 | |
| 28 | }}} |
| 29 | |
| 30 | BTW.Sorry my English and short text. |