Bug 21725: Use full statement in HAVING rather than constructed column
authorNick Clemens <nick@bywatersolutions.com>
Tue, 30 Oct 2018 11:59:26 +0000 (11:59 +0000)
committerMartin Renvoize <martin.renvoize@ptfs-europe.com>
Fri, 9 Nov 2018 16:15:49 +0000 (16:15 +0000)
commit45539696c16669dbc26810e403fccba48c2129f1
tree29d6cf5fb7ec435140ea18f179b1de35e5cf061c
parent18bb4d5e66f4bfc74144bce2f730359b55526b08
Bug 21725: Use full statement in HAVING rather than constructed column

To test:
1 - prove -v t/db_dpendent/Acquisition/GetBasketsInfosByBookseller.t
2 - Apply patch
3 - prove -v t/db_dpendent/Acquisition/GetBasketsInfosByBookseller.t
4 - It passes
5 - Have some open/closed and some fully and not full received baskets
6 - View a vendor and confirm baskets are shwn as expected
7 - Check 'Show all baskets' shows all baskets

Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Note sure this is the best thing but it fixes the issue

Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
(cherry picked from commit b5c456479da6a1033f9a697ca1bcf4295920aeb1)
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
C4/Acquisition.pm