Support for custom reports

[bsoudan]

Provide a method to support reports generated by Python code rather than just SQL. This would allow developers to write custom reports that pull data from other sources (e.g. the Subversion repository, site-specific databases, etc.) but still take advantage of the reporting framework. (e.g. sorting by clicking on column header, color coding, etc.)

Ideas as far as integrating this feature into Trac:

1) Re-rename 'View Tickets' back to 'Reports'? :)

2) Add a new module specifically for custom reports.

3) Only provide interface, coders should use framework to code new modules (e.g. each custom report would be its own module). This may work —

4) Aren't the Timeline and Searching features just custom reports?

5) Provide reports/ directory in trac environment for custom reports, scan this directory to provide listing.

[daniel]

Certainly a blue-sky idea, albeit a good one. :)

[Christopher Lenz]

I think you'd just write a plugin when we have TracPluggableModules.

[anonymous]

isnt this sort of the same as ticket 150?

[Christian Boos]

Milestone 2.0 deleted

[Christian Boos]

The report module could indeed benefit from some restructuring:

• real Report model
• pluggable interface for report providers (we already have 2 types currently, SQL and TicketQuery language)