|Version 4 (modified by 6 weeks ago) (diff),|
Table of Contents
Reporting subtickets for Trac
The functions are found in the
reporting subdirectory of the plugin code and will have to be installed by hand.
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.
tracsubticket_tree() stored function returns a depth-first search of all tickets and subtickets. A simple report using that function is:
SELECT r.id, path, parent, summary, component, CASE WHEN parent IS NULL THEN 'border-bottom:solid 3px #DDD;border-top: solid 3px #DDD;background-color:#DDD' ELSE 'text-indent: ' ||10*level||'px' END AS __style__ FROM tracsubticket_tree() r JOIN ticket t on r.id=t.id ORDER BY path
The result of this report query looks as follows:
Thanks to schneimi for the idea.