From 1aefaf9bca2022c806e07ba1cbd170336e85807a 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 Signed-off-by: Joy Nelson --- C4/Items.pm | 3 --- 1 file changed, 3 deletions(-) diff --git a/C4/Items.pm b/C4/Items.pm index 0f6017039c..2e83b0674b 100644 --- a/C4/Items.pm +++ b/C4/Items.pm @@ -2141,9 +2141,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