| 47 | === Adding More Reports === |
| 48 | To add reports to the Management screen sections, you must run the following sql against your trac database |
| 49 | Remember 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');''' |
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 === |
| 54 | To remove reports from the Management page, run the following query. |
| 55 | Remember 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).''' |