[Koha-bugs] [Bug 5675] Returned items always trigger hold notification

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

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

--- Comment #5 from Chris Cormack <chris at bigballofwax.co.nz> 2011-08-28 23:17:07 UTC ---
The problem query is

   SELECT items.biblionumber,
           items.biblioitemnumber,
           itemtypes.notforloan,
           items.notforloan AS itemnotforloan,
           items.itemnumber
    FROM   items
    LEFT JOIN biblioitems ON items.biblioitemnumber =
biblioitems.biblioitemnumber
    LEFT JOIN itemtypes   ON biblioitems.itemtype   = itemtypes.itemtype

This is wrong, because it doesnt use the itemlevel itype. It should check the
syspref and use the right level. Either biblio or item level

-- 
Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA Contact for the bug.