Changes between Version 38 and Version 39 of EstimationToolsPlugin


Ignore:
Timestamp:
Sep 27, 2012 9:12:45 PM (22 months ago)
Author:
rjollos
Comment:

Added Syntax highlighting.

Legend:

Unmodified
Added
Removed
Modified
  • EstimationToolsPlugin

    v38 v39  
    113113 * if you want to show the remaining hours column in your SQL reports, you need to join the ticket table with the ticket_custom table, which contains the custom fields.  
    114114        {{{ 
     115        #!sql 
    115116SELECT 
    116   ...                                    # normal SELECT statement 
     117  ...                                      # normal SELECT statement 
    117118  id AS ticket, 
    118119  COALESCE(tc.value,'') as estimatedhours, # adds the value of estimatedhours in a column that must have same name original field 
    119120  FROM ticket t 
    120   LEFT JOIN ...                          # other LEFT JOIN statements (in the default Trac queries) can be left in place 
     121  LEFT JOIN ...                            # other LEFT JOIN statements (in the default Trac queries) can be left in place 
    121122  LEFT JOIN ticket_custom tc ON tc.ticket = t.id and tc.name = 'estimatedhours' 
    122123  ... 
     
    146147 1. '''Add''' a custom field into 'trac.ini' file to store the estimations for the current remaining effort, as follows: 
    147148{{{ 
    148 [ticket-custom] 
    149 estimatedhours = text 
    150 estimatedhours.label = Remaining Hours 
    151 estimatedhours.value = 0 
     149#!ini 
     150 [ticket-custom] 
     151 estimatedhours = text 
     152 estimatedhours.label = Remaining Hours 
     153 estimatedhours.value = 0 
    152154}}} 
    153155 1. '''Enable''' the plugin by updating TracIni file (..../trac.ini) as follows: 
    154156{{{ 
     157#!ini 
    155158 [components] 
    156159 estimationtools.* = enabled 
     
    158161 1. '''Configure''' the plugin at its own configuration section, placed into 'trac.ini' file as follows:  
    159162{{{ 
    160 [estimation-tools] 
    161 # if you want to use another field than estimatedhours you can change that 
    162 estimation_field = estimatedhours  
    163 # Set to a comma separated list of workflow states  
    164 # that count as zero in BurnDownChart. Defaults to 'closed' 
    165 closed_states = closed,another_state   
    166 # Suffix used for estimations. Defaults to 'h' 
    167 estimation_suffix = points         
    168 # If you want charts to be served from the server set to true. Useful for SSL connections. Default 'false' 
    169 serverside_charts = false 
     163#!ini 
     164 [estimation-tools] 
     165 # if you want to use another field than estimatedhours you can change that 
     166 estimation_field = estimatedhours  
     167 # Set to a comma separated list of workflow states  
     168 # that count as zero in BurnDownChart. Defaults to 'closed' 
     169 closed_states = closed,another_state   
     170 # Suffix used for estimations. Defaults to 'h' 
     171 estimation_suffix = points         
     172 # If you want charts to be served from the server set to true. Useful for SSL connections. Default 'false' 
     173 serverside_charts = false 
    170174}}} 
    171175 4. '''Restart''' web server on command line: 
     
    211215 
    212216'''Author:''' [wiki:hoessler] [[BR]] 
     217'''Maintainer:''' [wiki:hoessler] [[BR]] 
    213218'''Contributors:''' [wiki:osimons]