Changes between Version 7 and Version 8 of EstimationToolsPlugin


Ignore:
Timestamp:
Oct 6, 2008 8:06:51 AM (6 years ago)
Author:
iaindb@…
Comment:

How to edit your reports to use the estimated hours field. I don't know much SQL, so correct me if I'm wrong!

Legend:

Unmodified
Added
Removed
Modified
  • EstimationToolsPlugin

    v7 v8  
    129129[[Image(HoursInPlaceEditor.png)]] 
    130130 
     131=== Customising Queries === 
     132 
     133To 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: 
     134{{{ 
     135SELECT 
     136  ...                         # normal SELECT statement 
     137  id AS ticket, 
     138  ifnull(tc.value,'') as Hrs, # adds the value of estimatedhours in a column called Hrs, using '' if it doesn't exist. 
     139  FROM ticket t 
     140  LEFT JOIN ...               # other LEFT JOIN statements (in the default Trac queries) can be left in place 
     141  LEFT JOIN ticket_custom tc ON tc.ticket = t.id and tc.name = 'estimatedhours' 
     142  ... 
     143}}} 
     144 * You could change Hrs to 'Remaining Hours' to modify the column name. 
     145 * You could change {{{''}}} to '0' to show 0 hours for tickets that don't have a corresponding estimatedhours field. 
     146 * Tickets may have an estimated hours field that is empty, in which case you may still see "blank" 
     147 
    131148== Recent Changes == 
    132149