[Koha-bugs] [Bug 8364] New: Inconsistency in hold count

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Thu Jul 5 15:21:41 CEST 2012


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

          Priority: P5 - low
 Change sponsored?: ---
            Bug ID: 8364
                CC: gmcharlt at gmail.com, kyle.m.hall at gmail.com
          Assignee: koha-bugs at lists.koha-community.org
           Summary: Inconsistency in hold count
          Severity: normal
    Classification: Unclassified
                OS: All
          Reporter: paul.poulain at biblibre.com
          Hardware: All
            Status: NEW
           Version: master
         Component: Circulation
           Product: Koha

If a Koha is set with ReservesControlBranch syspref set to ItemHomeLibrary
item-level-itype=yes, a patron placing a "first available" hold won't be
counted in the total number of reserves placed.
The SQL is SELECT 
  count(*) as count
  FROM reserves
  LEFT JOIN items USING (itemnumber)
  LEFT JOIN biblioitems ON (reserves.biblionumber=biblioitems.biblionumber)
  LEFT JOIN borrowers USING (borrowernumber)
WHERE ...
  AND items.homebranch = ?

=> items is not defined, the hold is not counted

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


More information about the Koha-bugs mailing list