Supply subtotal and grand total rows in reports that use aggregate functions
Bug #1789679 reported by
Mike Rylander
This bug affects 3 people
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Evergreen |
Fix Released
|
Wishlist
|
Unassigned |
Bug Description
NOTE: this change requires Postgres 9.5 or later be the minimum version for Evergreen!
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 are a mix of aggregate and non-aggregate columns in a report.
Branch coming soon to implement that...
tags: | added: needsreleasenote |
Changed in evergreen: | |
milestone: | 3.next → 3.3-beta1 |
Changed in evergreen: | |
milestone: | 3.3-beta1 → 3.3-rc |
Changed in evergreen: | |
milestone: | 3.3-rc → 3.next |
tags: | added: signedoff |
Changed in evergreen: | |
assignee: | nobody → Galen Charlton (gmc) |
Changed in evergreen: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
Branch coordinates: http:// git.evergreen- ils.org/ ?p=working/ Evergreen. git;a=shortlog; h=refs/ heads/user/ miker/lp- 1789679- report- rollup