Edgewall Software

Changes between Initial Version and Version 1 of TracIniReportCustomFieldSample


Ignore:
Timestamp:
Feb 9, 2005, 10:44:41 AM (18 years ago)
Author:
anonymous
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • TracIniReportCustomFieldSample

    v1 v1  
     1'''Report whith CustomFields'''
     2
     3This es a simple Custom Repor with Custom Ticktes Fields.
     4
     5A report show a Milestone sumarize time inverted, new field test_one is Time to resovle a Ticket.
     6
     7Enjoy!
     8
     9Trac.ini
     10{{{
     11
     12[ticket-custom]
     13test_one = text
     14test_one.label = Inverted Time
     15
     16}}}
     17
     18Custom SQL
     19{{{
     20SELECT
     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
     30BTW.Sorry my English and short text.