Changes between Version 9 and Version 10 of TimeEstimationUserManual


Ignore:
Timestamp:
Jun 28, 2007, 1:49:19 PM (17 years ago)
Author:
Russ Tyndall
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • TimeEstimationUserManual

    v9 v10  
    3232
    3333== Reports ==
     34=== Report Types ===
    3435We provide a few different reports for querying different types of data:
    3536    * '''Billing Reports''' Currently the billing reports are the only time based reports, and are therefore useful for getting an estimate what tickets had times (and totals), and which developers spent their time where.
     
    4445       * Ticket Hours Grouped By Milestone
    4546       * Ticket Hours Grouped By Milestone with Description
     47=== Adding More Reports ===
     48To add reports to the Management screen sections, you must run the following sql against your trac database
     49Remember to fill in the @reportID of the report you want to insert, and to select the insert statement for the section of your choice.
     50 * '''INSERT INTO report_version (report, version, tags) VALUES ( @reportID , 1, 'Ticket/Hour Reports');'''
     51 * '''INSERT INTO report_version (report, version, tags) VALUES ( @reportID , 1, 'Billing Reports');'''
    4652
    47  '''Note that the reports can only be called from the Mangement Page. They will not work from the Trac View Tickets page.'''
     53=== Removing a Report ===
     54To remove reports from the Management page, run the following query.
     55Remember to fill in the @reportID of the report you want to insert, and to select the insert statement for the section of your choice.
     56 * To remove for this version of the plugin (will be over written in future plugin upgrades)
     57   * '''UPDATE report_version SET tags=!'' WHERE report = @reportID ;'''
     58 * To remove permanently (wont be over written in future plugin upgrades)
     59   * '''UPDATE report_version SET version=9999, tags=!'' WHERE report = @reportID ;'''
     60
     61=== TAKE NOTE ===
     62 '''The reports can only be called from the Mangement Page. They will not work from the Trac View Tickets page. (Due to the custom variables that need values).'''
    4863
    4964== Future Improvements ==