Changes between Version 45 and Version 46 of EstimationToolsPlugin
- Timestamp:
- Aug 3, 2017, 10:16:47 AM (7 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
EstimationToolsPlugin
v45 v46 1 1 [[PageOutline(2-5,Contents,pullout)]] 2 2 3 = Tools for visualizing and quickediting of effort estimations3 = Tools for visualizing and editing of effort estimations 4 4 5 5 == Description … … 106 106 This component allows to edit the remaining hours field directly in the custom query view as well as in the report view. 107 107 108 [[Image(HoursInPlaceEditor.png )]]109 110 Notes:108 [[Image(HoursInPlaceEditor.png, border=2)]] 109 110 '''Notes''': 111 111 * To show the remaining hours in the custom query view, you have to enable the corresponding column. 112 112 * 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: 113 113 {{{#!sql 114 114 SELECT 115 ... #normal SELECT statement115 ... -- normal SELECT statement 116 116 id AS ticket, 117 COALESCE(tc.value, '') AS estimatedhours #adds the value of estimatedhours in a column that must have same name original field117 COALESCE(tc.value, '') AS estimatedhours -- adds the value of estimatedhours in a column that must have same name original field 118 118 FROM ticket t 119 LEFT JOIN ... #other LEFT JOIN statements (in the default Trac queries) can be left in place119 LEFT JOIN ... -- other LEFT JOIN statements (in the default Trac queries) can be left in place 120 120 LEFT JOIN ticket_custom tc ON tc.ticket = t.id AND tc.name = 'estimatedhours' 121 121 ...