From b462dfc66a23d53088e6ad0b9bfa7354a8347cae Mon Sep 17 00:00:00 2001
From: Francesca Moore <francescalamoore@gmail.com>
Date: Wed, 15 Jan 2014 12:03:51 +1300
Subject: [PATCH] Bug 11231: remove reference to ambiguous notes column from
 two hold request reports

The 'notes' column has been removed from the pending holds and hold
ratios reports as they were not displaying in the first place.

1.apply patch
2.verify that both reports work

Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
Signed-off-by: Jonathan Druart <jonathan.druart@biblibre.com>
Signed-off-by: Galen Charlton <gmc@esilibrary.com>
(cherry picked from commit cc34a816a10ca76004e079032f1a46aec1ccb1c4)
Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
---
 circ/pendingreserves.pl | 2 --
 circ/reserveratios.pl   | 3 +--
 2 files changed, 1 insertion(+), 4 deletions(-)

diff --git a/circ/pendingreserves.pl b/circ/pendingreserves.pl
index 0110debea0..c34c52c056 100755
--- a/circ/pendingreserves.pl
+++ b/circ/pendingreserves.pl
@@ -124,7 +124,6 @@ if ( $run_report ) {
             GROUP_CONCAT(DISTINCT items.copynumber
                     ORDER BY items.itemnumber SEPARATOR '<br/>') l_copynumber,
             items.itemnumber,
-            notes,
             notificationdate,
             reminderdate,
             max(priority) as priority,
@@ -183,7 +182,6 @@ if ( $run_report ) {
                 itemcallnumber  => $data->{l_itemcallnumber},
                 enumchron       => $data->{l_enumchron},
                 copyno          => $data->{l_copynumber},
-                notes           => $data->{notes},
                 notificationdate=> $data->{notificationdate},
                 reminderdate    => $data->{reminderdate},
                 count           => $data->{icount},
diff --git a/circ/reserveratios.pl b/circ/reserveratios.pl
index 55eb01825a..bb5eb24d90 100755
--- a/circ/reserveratios.pl
+++ b/circ/reserveratios.pl
@@ -99,7 +99,7 @@ my $strsth =
         		ORDER BY items.itemnumber SEPARATOR '<br/>') as l_location,
         GROUP_CONCAT(DISTINCT items.itype 
         		ORDER BY items.itemnumber SEPARATOR '<br/>') as l_itype,
-        notes,
+
         reserves.found,
         biblio.title,
         biblio.author,
@@ -141,7 +141,6 @@ while ( my $data = $sth->fetchrow_hashref ) {
             title            => $data->{title},
             subtitle            => $data->{subtitle},
             author           => $data->{author},
-            notes            => $data->{notes},
             itemnum          => $data->{itemnumber},
             biblionumber     => $data->{biblionumber},
             holdingbranch    => $data->{holdingbranch},
-- 
2.39.5