Changes between Version 24 and Version 25 of EstimationToolsPlugin


Ignore:
Timestamp:
Jun 24, 2010 5:09:41 PM (4 years ago)
Author:
anonymous
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • EstimationToolsPlugin

    v24 v25  
    149149  ...                                    # normal SELECT statement 
    150150  id AS ticket, 
    151   ifnull(tc.value,'') as estimatedhours, # adds the value of estimatedhours in a column that must have same name original field 
     151  COALESCE(tc.value,'') as estimatedhours, # adds the value of estimatedhours in a column that must have same name original field 
    152152  FROM ticket t 
    153153  LEFT JOIN ...                          # other LEFT JOIN statements (in the default Trac queries) can be left in place