[Koha-bugs] [Bug 8843] New: Cannot export bibliographic records by call number

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8843

          Priority: P5 - low
 Change sponsored?: ---
            Bug ID: 8843
          Assignee: oleonard at myacpl.org
           Summary: Cannot export bibliographic records by call number
          Severity: normal
    Classification: Unclassified
                OS: All
          Reporter: oleonard at myacpl.org
          Hardware: All
            Status: ASSIGNED
           Version: master
         Component: Tools
           Product: Koha

The logic is wrong when building the query:

if ($start_callnumber) {
    $sql_query .= " AND itemcallnumber <= ? ";
    push @sql_params, $start_callnumber;
}

if ($end_callnumber) {
    $sql_query .= " AND itemcallnumber >= ? ";
    push @sql_params, $end_callnumber;
}

The query must include items with call numbers *greater than* the starting call
number and *less than* the ending call number, not vice versa.

-- 
You are receiving this mail because:
You are watching all bug changes.