Bug 21622: Adjust incorrect GROUP BY clauses in acqui script
authorJonathan Druart <jonathan.druart@bugs.koha-community.org>
Fri, 19 Oct 2018 15:18:19 +0000 (12:18 -0300)
committerroot <root@f1ebe1bec408>
Fri, 22 Feb 2019 13:06:17 +0000 (13:06 +0000)
commit2d904a55e7f0d5da23d61e5272e36a75e4b68af2
tree19facb00c5531860805f07abb1bb15eb6c3d9177
parent25006c04da500078b2af1b14824b67076f2f9df5
Bug 21622: Adjust incorrect GROUP BY clauses in acqui script

acqui/ordered.pl:    GROUP BY aqorders.ordernumber
acqui/spent.pl:    GROUP BY aqorders.ordernumbe

'koha_kohadev.aqorders.biblionumber' isn't in GROUP BY

Test plan:
- Create orders for different basket and using different funds
- Receive some of them
- Hit the ordered and spent pages (from the acqui home page)
=> The tables must contain the same data with and without this patch

Signed-off-by: Jasmine Amohia <jasmineamohia.student@wegc.school.nz>

Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>

Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
acqui/ordered.pl
acqui/spent.pl