kalenjordan/custom-reports — pull request #5 by LeeSaferite (2014-05-17 17:23:28+00:00)
Title: Stored Report Results and Charts Refactoring

This is the stored report result from the hackathon along with a refactoring of charts to work better with the reports.

You can now run a report and the result will be stored in a table in the DB to facilitate faster browsing of the results and historical storage of previous runs.

Charts have been refactored into a new model type that has a nullable ref to a report. If you link a chart to a report then you can use {{table}} to reference the latest result table from the report in the chart SQL. This allows us to reuse a report for multiple charts. Additionally, a chart can be unlinked and instead generate the report data live via the chart SQL.

The connection choosing code from beeplogic was removed due to incompatibility with the new report result tables. We can and should evaluate how to accomplish this same behavior with the latest code.