[Koha-bugs] [Bug 11045] Wrong query in C4/Biblios.pm : join between biblioitems.itemtypes and itemtypes table

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

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

--- Comment #1 from Jared Camins-Esakov <jcamins at cpbibliography.com> ---
(In reply to mathieu saby from comment #0)
> C4::Biblios::GetBiblioData and GetBiblioItemData are doing : 
> SELECT [...] itemtypes.notforloan  [...]
> [...]
> LEFT JOIN itemtypes ON biblioitems.itemtype = itemtypes.itemtype
> 
> This is wrong becaause itemtypes table could be linked with items.itype (as
> in my library) and not with biblioitems.itemtype.

Actually, I think this is correct, since this is for biblio-level item types,
rather than item-level, which are treated elsewhere. You toggle between the two
with the item-level_itypes syspref.

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