From 9954e513bf755801a9f223d64e2622b1f4978991 Mon Sep 17 00:00:00 2001 From: Marcel de Rooy Date: Fri, 19 Apr 2024 07:21:57 +0000 Subject: [PATCH] Bug 36018: (follow-up) Disambiguate quantity One of the embeds refers to suggestions. This table also has a quantity column. Test plan: Verify that Pending Orders table does load now instead of triggering an internal server error on ambiguous column. Signed-off-by: Marcel de Rooy Signed-off-by: Martin Renvoize --- Koha/Acquisition/Orders.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Koha/Acquisition/Orders.pm b/Koha/Acquisition/Orders.pm index 2e8a9070e30..0911981cd7f 100644 --- a/Koha/Acquisition/Orders.pm +++ b/Koha/Acquisition/Orders.pm @@ -166,7 +166,7 @@ sub filter_by_active { 'orderstatus' => [ 'new', 'ordered', 'partial' ] }, { 'orderstatus' => [ 'ordered', 'partial' ] } ], - quantityreceived => { '<', \['COALESCE(quantity,0)'] }, + quantityreceived => { '<', \['COALESCE(me.quantity,0)'] }, }, { join => 'basket' } ); -- 2.45.0