From 2ed3e852f14f11b6454dc3214c58735719ef88d9 Mon Sep 17 00:00:00 2001 From: Owen Leonard Date: Wed, 21 Nov 2012 15:08:45 -0500 Subject: [PATCH] Bug 8843 [3.8.x] Cannot export bibliographic records by call number Reworked for 3.8.x: When building the query for exports by call number the script has the logic reversed. It tries to select records with call numbers less than the starting call number and greater than the ending call number. This should be reversed. To test, test an export in an unpatched system. An export by call number will return an empty file. After applying the patch an export by call number should give valid results. Signed-off-by: Jonathan Druart Signed-off-by: Chris Cormack --- tools/export.pl | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/tools/export.pl b/tools/export.pl index d3d8646c4d..c7f309108c 100755 --- a/tools/export.pl +++ b/tools/export.pl @@ -102,12 +102,12 @@ if ($op eq "export") { } if ($start_callnumber) { - $query .= " AND itemcallnumber <= ? "; + $query .= " AND itemcallnumber >= ? "; push @sql_params, $start_callnumber; } if ($end_callnumber) { - $query .= " AND itemcallnumber >= ? "; + $query .= " AND itemcallnumber <= ? "; push @sql_params, $end_callnumber; } if ($start_accession) { -- 2.39.5