Changes between Version 20 and Version 21 of EstimationToolsPlugin

Timestamp:

Mar 15, 2009, 2:06:40 PM (15 years ago)

Author:

Joachim Hoessler

Comment:

--

EstimationToolsPlugin

@@ -138 +138 @@
 === !HoursInPlaceEditor ===
 
-This component allows to edit the remaining hours field directly in the query view.
+This component allows to edit the remaining hours field directly in the custom query view as well as in the report view.
 
 [[Image(HoursInPlaceEditor.png)]]
 
-== Tips ==
-=== Customising Queries ===
+ * to show the remaining hours in the custom query view, you have to enable the corresponding column
 
-If you want to 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. However, please note that the !HoursInPlaceEditor won't work with these reports, but only with "custom queries".
+ * 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. 
 
-{{{
+        {{{
 SELECT
-  ...                         # normal SELECT statement
+  ...                                    # normal SELECT statement
   id AS ticket,
-  ifnull(tc.value,'') as Hrs, # adds the value of estimatedhours in a column called Hrs, using '' if it doesn't exist.
+  ifnull(tc.value,'') as estimatedhours, # adds the value of estimatedhours in a column that must have same name original field
   FROM ticket t
-  LEFT JOIN ...               # other LEFT JOIN statements (in the default Trac queries) can be left in place
+  LEFT JOIN ...                          # other LEFT JOIN statements (in the default Trac queries) can be left in place
   LEFT JOIN ticket_custom tc ON tc.ticket = t.id and tc.name = 'estimatedhours'
   ...
-}}}
- * You could change Hrs to 'Remaining Hours' to modify the column name.
- * You could change {{{''}}} to '0' to show 0 hours for tickets that don't have a corresponding estimatedhours field.
- * Tickets may have an estimated hours field that is empty, in which case you may still see "blank"
+        }}}
+         * You could change {{{''}}} to '0' to show 0 hours for tickets that don't have a corresponding estimated hours field.
+         * Tickets may have an estimated hours field that is empty, in which case you may still see "blank"
 
 == Recent Changes ==