From caec1ddfa48b3bf8581b27dc45cba404a47d4a27 Mon Sep 17 00:00:00 2001 From: Owen Leonard Date: Fri, 28 Sep 2012 10:48:16 -0400 Subject: [PATCH] Bug 8843 - Cannot export bibliographic records by call number 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: Nicole C. Engard Works as expected. Signed-off-by: Paul Poulain --- tools/export.pl | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/tools/export.pl b/tools/export.pl index a4eb6e9dde..c7a8fd818e 100755 --- a/tools/export.pl +++ b/tools/export.pl @@ -538,12 +538,12 @@ sub construct_query { } if ($start_callnumber) { - $sql_query .= " AND itemcallnumber <= ? "; + $sql_query .= " AND itemcallnumber >= ? "; push @sql_params, $start_callnumber; } if ($end_callnumber) { - $sql_query .= " AND itemcallnumber >= ? "; + $sql_query .= " AND itemcallnumber <= ? "; push @sql_params, $end_callnumber; } if ($start_accession) { -- 2.39.5