From 1aefaf9bca2022c806e07ba1cbd170336e85807a Mon Sep 17 00:00:00 2001
From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
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 <lucas@bywatersolutions.com>
Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>

Signed-off-by: Joy Nelson <joy@bywatersolutions.com>
---
 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