Changes between Version 3 and Version 4 of SubticketsPlugin/Reporting
- Timestamp:
- Jan 11, 2017, 9:19:21 PM (7 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
SubticketsPlugin/Reporting
v3 v4 5 5 The plugin SubticketsPlugin contains stored functions that can aid in the reporting of subticket hierarchies in Trac. Using such functions is necessary due to TracReports rewriting of SQL queries. 6 6 7 The functions are found in the `reporting` [https://github.com/trac-hacks/trac-subtickets-plugin/tree/master/tracsubtickets/reporting s subdirectory of the plugin code].7 The functions are found in the `reporting` [https://github.com/trac-hacks/trac-subtickets-plugin/tree/master/tracsubtickets/reporting subdirectory of the plugin code] and will have to be installed by hand. 8 8 9 Currently only PostgreSQL is supported. The query technique used is supported by at least MySql and SQLServer, but theDDLs differ slightly. Patches are welcome.9 Currently. only PostgreSQL is supported. The query technique used is supported by at least MySql and SQLServer, but their DDLs differ slightly. Patches are welcome. 10 10 11 11 == Simple Example 12 12 13 The `tracsubticket_tree()` function returns a depth-first search of all tickets and subtickets. A simple report using that function is:13 The `tracsubticket_tree()` stored function returns a depth-first search of all tickets and subtickets. A simple report using that function is: 14 14 15 15 {{{#!sql