Changes between Version 38 and Version 39 of EstimationToolsPlugin
- Timestamp:
- Sep 27, 2012, 7:12:45 PM (11 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
EstimationToolsPlugin
v38 v39 113 113 * 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. 114 114 {{{ 115 #!sql 115 116 SELECT 116 ... # normal SELECT statement117 ... # normal SELECT statement 117 118 id AS ticket, 118 119 COALESCE(tc.value,'') as estimatedhours, # adds the value of estimatedhours in a column that must have same name original field 119 120 FROM ticket t 120 LEFT JOIN ... # other LEFT JOIN statements (in the default Trac queries) can be left in place121 LEFT JOIN ... # other LEFT JOIN statements (in the default Trac queries) can be left in place 121 122 LEFT JOIN ticket_custom tc ON tc.ticket = t.id and tc.name = 'estimatedhours' 122 123 ... … … 146 147 1. '''Add''' a custom field into 'trac.ini' file to store the estimations for the current remaining effort, as follows: 147 148 {{{ 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 152 154 }}} 153 155 1. '''Enable''' the plugin by updating TracIni file (..../trac.ini) as follows: 154 156 {{{ 157 #!ini 155 158 [components] 156 159 estimationtools.* = enabled … … 158 161 1. '''Configure''' the plugin at its own configuration section, placed into 'trac.ini' file as follows: 159 162 {{{ 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 170 174 }}} 171 175 4. '''Restart''' web server on command line: … … 211 215 212 216 '''Author:''' [wiki:hoessler] [[BR]] 217 '''Maintainer:''' [wiki:hoessler] [[BR]] 213 218 '''Contributors:''' [wiki:osimons]