LP#1789679: Provide ROLLUP support in report output
authorMike Rylander <mrylander@gmail.com>
Wed, 29 Aug 2018 15:39:30 +0000 (11:39 -0400)
committerGalen Charlton <gmc@equinoxinitiative.org>
Mon, 24 Aug 2020 15:40:27 +0000 (11:40 -0400)
commitae290c43e8e28a364e718b58d2be19666601ef16
treef42de54a442351fbf2a3f2b096dcfad23795fd93
parent776c1eaf44424bcb146e74e82f114b66fd02e17b
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>
Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
Signed-off-by: Lynn Floyd <lfloyd1@library.in.gov>
Signed-off-by: Galen Charlton <gmc@equinoxinitiative.org>
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