Changes between Version 38 and Version 39 of EstimationToolsPlugin


Ignore:
Timestamp:
Sep 27, 2012, 7:12:45 PM (11 years ago)
Author:
Ryan J Ollos
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]