]> git.koha-community.org Git - koha.git/commit
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)
committerMartin Renvoize <martin.renvoize@ptfs-europe.com>
Tue, 26 Feb 2019 09:22:15 +0000 (09:22 +0000)
commit7d30e64996100bf0fb5a803cd6e1dcdbd8f01e20
tree04d53c84d41919cd4ab5e7a83fc4e157210c3b1d
parent111ddbfa573df0fd5d694f1a96a2a5063e8dfb47
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>
(cherry picked from commit 2d904a55e7f0d5da23d61e5272e36a75e4b68af2)
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
acqui/ordered.pl
acqui/spent.pl