From abbfb47906d253815c4b70d2efa1801ddd2dba8d Mon Sep 17 00:00:00 2001 From: Lari Taskula Date: Thu, 15 Jun 2017 19:18:10 +0300 Subject: [PATCH] Bug 13707: (squashable) Column 'datereceived' in where clause is ambiguous To test: 1. prove t/db_dependent/Acquisition.t --- C4/Acquisition.pm | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/C4/Acquisition.pm b/C4/Acquisition.pm index ed80b26..29ec539 100644 --- a/C4/Acquisition.pm +++ b/C4/Acquisition.pm @@ -2132,8 +2132,8 @@ sub GetLateOrders { LEFT JOIN aqbooksellers ON aqbasket.booksellerid = aqbooksellers.id LEFT JOIN aqbasketgroups ON aqbasket.basketgroupid = aqbasketgroups.id WHERE aqorders.basketno = aqbasket.basketno - AND ( datereceived = '' - OR datereceived IS NULL + AND ( aqorders.datereceived = '' + OR aqorders.datereceived IS NULL OR aqorders.quantityreceived < aqorders.quantity ) AND aqbasket.closedate IS NOT NULL -- 2.7.4