Changes between Version 24 and Version 25 of EstimationToolsPlugin


Ignore:
Timestamp:
Jun 24, 2010, 3:09:41 PM (14 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