[[TOC]]

The plugin contains stored functions that can aid reporting of subticket hierarchies. Using such functions is necessary due to TracReports rewriting of SQL queries.

The functions are found in the `reporting` [https://github.com/trac-hacks/trac-subtickets-plugin/tree/master/tracsubtickets/reportings subdirectory of the plugin code]

Currently only PostgreSQL is supported. The query technique used is supported by at least MySql and SQLServer, but the DDLs differ slightly. Patches are welcome.
  
== Simple Example ==

The `tracsubticket_tree()` function returns a depth-first search of all tickets and subtickets. A simple report using that function is:

{{{#!sql
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 like this:

[[Image(tracsubtickets_simple_report)]]

Thanks to [https://schneimi.wordpress.com/2013/02/02/trac-subticketsplugin-with-progress-bar-and-report/ schneimi] for the idea.