From abc00eb1cfd1ee018396d6df04e6f28d7b363dbb Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Mon, 27 Apr 2020 11:51:35 +0200 Subject: [PATCH] Bug 23081: Revert "Bug 24443: Consider NULL as 0 for issues in items search" This reverts commit 80f1374f262544a750b5d81a7d9605c8708c53b1. Signed-off-by: Lucas Gass Signed-off-by: Jonathan Druart Signed-off-by: Martin Renvoize --- C4/Items.pm | 3 --- 1 file changed, 3 deletions(-) diff --git a/C4/Items.pm b/C4/Items.pm index f0fe9fc750..a162ac5dec 100644 --- a/C4/Items.pm +++ b/C4/Items.pm @@ -1342,9 +1342,6 @@ sub _SearchItems_build_where_fragment { } $column = "ExtractValue($sqlfield, '$xpath')"; } - } elsif ($field eq 'issues') { - # Consider NULL as 0 for issues count - $column = 'COALESCE(issues,0)'; } else { $column = $field; } -- 2.39.5