Changes between Version 20 and Version 21 of EstimationToolsPlugin


Ignore:
Timestamp:
Mar 15, 2009 3:06:40 PM (6 years ago)
Author:
hoessler
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • EstimationToolsPlugin

    v20 v21  
    138138=== !HoursInPlaceEditor === 
    139139 
    140 This component allows to edit the remaining hours field directly in the query view. 
     140This component allows to edit the remaining hours field directly in the custom query view as well as in the report view. 
    141141 
    142142[[Image(HoursInPlaceEditor.png)]] 
    143143 
    144 == Tips == 
    145 === Customising Queries === 
     144 * to show the remaining hours in the custom query view, you have to enable the corresponding column 
    146145 
    147 If you want to show the remaining hours column in your SQL queries, you need to join the ticket table with the ticket_custom table, which contains the custom fields. However, please note that the !HoursInPlaceEditor won't work with these reports, but only with "custom queries". 
     146 * 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.  
    148147 
    149 {{{ 
     148        {{{ 
    150149SELECT 
    151   ...                         # normal SELECT statement 
     150  ...                                    # normal SELECT statement 
    152151  id AS ticket, 
    153   ifnull(tc.value,'') as Hrs, # adds the value of estimatedhours in a column called Hrs, using '' if it doesn't exist. 
     152  ifnull(tc.value,'') as estimatedhours, # adds the value of estimatedhours in a column that must have same name original field 
    154153  FROM ticket t 
    155   LEFT JOIN ...               # other LEFT JOIN statements (in the default Trac queries) can be left in place 
     154  LEFT JOIN ...                          # other LEFT JOIN statements (in the default Trac queries) can be left in place 
    156155  LEFT JOIN ticket_custom tc ON tc.ticket = t.id and tc.name = 'estimatedhours' 
    157156  ... 
    158 }}} 
    159  * You could change Hrs to 'Remaining Hours' to modify the column name. 
    160  * You could change {{{''}}} to '0' to show 0 hours for tickets that don't have a corresponding estimatedhours field. 
    161  * Tickets may have an estimated hours field that is empty, in which case you may still see "blank" 
     157        }}} 
     158         * You could change {{{''}}} to '0' to show 0 hours for tickets that don't have a corresponding estimated hours field. 
     159         * Tickets may have an estimated hours field that is empty, in which case you may still see "blank" 
    162160 
    163161== Recent Changes ==