Bug 8364

Summary: Inconsistency in hold count
Product: Koha Reporter: Paul Poulain <paul.poulain>
Component: CirculationAssignee: Bugs List <koha-bugs>
Status: CLOSED FIXED QA Contact:
Severity: normal    
Priority: P5 - low CC: claire.hernandez, gmcharlt, jonathan.druart, kyle.m.hall
Version: Main   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Bug Depends on:    
Bug Blocks: 8362    

Description Paul Poulain 2012-07-05 13:21:41 UTC
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
Comment 1 Jonathan Druart 2015-04-07 13:46:02 UTC
This seems to be fixed, please reopen if I am wrong.