From cc34a816a10ca76004e079032f1a46aec1ccb1c4 Mon Sep 17 00:00:00 2001 From: Francesca Moore 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 Signed-off-by: Jonathan Druart Signed-off-by: Galen Charlton --- 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 '
') 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 '
') as l_location, GROUP_CONCAT(DISTINCT items.itype ORDER BY items.itemnumber SEPARATOR '
') 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.20.1