Changes between Version 24 and Version 25 of EstimationToolsPlugin
- Timestamp:
- Jun 24, 2010, 3:09:41 PM (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
EstimationToolsPlugin
v24 v25 149 149 ... # normal SELECT statement 150 150 id AS ticket, 151 ifnull(tc.value,'') as estimatedhours, # adds the value of estimatedhours in a column that must have same name original field151 COALESCE(tc.value,'') as estimatedhours, # adds the value of estimatedhours in a column that must have same name original field 152 152 FROM ticket t 153 153 LEFT JOIN ... # other LEFT JOIN statements (in the default Trac queries) can be left in place