Changes between Version 45 and Version 46 of EstimationToolsPlugin


Ignore:
Timestamp:
Aug 3, 2017, 10:16:47 AM (7 years ago)
Author:
figaro
Comment:

Further cosmetic changes

Legend:

Unmodified
Added
Removed
Modified
  • EstimationToolsPlugin

    v45 v46  
    11[[PageOutline(2-5,Contents,pullout)]]
    22
    3 = Tools for visualizing and quick editing of effort estimations
     3= Tools for visualizing and editing of effort estimations
    44
    55== Description
     
    106106This component allows to edit the remaining hours field directly in the custom query view as well as in the report view.
    107107
    108 [[Image(HoursInPlaceEditor.png)]]
    109 
    110 Notes:
     108[[Image(HoursInPlaceEditor.png, border=2)]]
     109
     110'''Notes''':
    111111 * To show the remaining hours in the custom query view, you have to enable the corresponding column.
    112112 * 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:
    113113 {{{#!sql
    114114SELECT
    115   ...                                      # normal SELECT statement
     115  ...                                      -- normal SELECT statement
    116116  id AS ticket,
    117   COALESCE(tc.value, '') AS estimatedhours # adds the value of estimatedhours in a column that must have same name original field
     117  COALESCE(tc.value, '') AS estimatedhours -- adds the value of estimatedhours in a column that must have same name original field
    118118  FROM ticket t
    119   LEFT JOIN ...                            # other LEFT JOIN statements (in the default Trac queries) can be left in place
     119  LEFT JOIN ...                            -- other LEFT JOIN statements (in the default Trac queries) can be left in place
    120120  LEFT JOIN ticket_custom tc ON tc.ticket = t.id AND tc.name = 'estimatedhours'
    121121  ...