]> git.evergreen-ils.org Git - working/Evergreen.git/commit
LP#1789679: Provide ROLLUP support in report output user/miker/lp-1789679-report-rollup
authorMike Rylander <mrylander@gmail.com>
Wed, 29 Aug 2018 15:39:30 +0000 (11:39 -0400)
committerMike Rylander <mrylander@gmail.com>
Fri, 21 Feb 2020 20:51:31 +0000 (15:51 -0500)
commita9cb3e5104fe57b0cea12a87a81495d13721f0f1
tree0ee4c1613754c7dada06ee105a5ac8b621955cde
parent473688892df7ee175d44930c5cea438d44d01992
LP#1789679: Provide ROLLUP support in report output

In Postgres 9.5 and newer, it is simple to generate group subtotal and grand
total rows for aggregate queries. The simplest thing would be to spell the
grouping clause as

  GROUP BY ROLLUP (...)

rather than

  GROUP BY ...

when there is a mix of aggregate and non-aggregate columns in a report.  This
branch does just that.

The report definition UI now has a checkbox labeled "Calculate grouping
subtotals" which enables use of the ROLLUP functionality.

Signed-off-by: Mike Rylander <mrylander@gmail.com>
Open-ILS/src/perlmods/lib/OpenILS/Reporter/SQLBuilder.pm
Open-ILS/src/reporter/clark-kent.pl
Open-ILS/web/opac/locale/en-US/reports.dtd
Open-ILS/web/reports/oils_rpt_editor.xhtml
Open-ILS/web/reports/oils_rpt_report_editor.js