From 01ff8ab4e7bb486fba0cd52cbe03629b282ef317 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: Jonathan Druart --- C4/Items.pm | 3 --- 1 file changed, 3 deletions(-) diff --git a/C4/Items.pm b/C4/Items.pm index bbc5a7cd1f..5674d7e46b 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.20.1