[Koha-bugs] [Bug 36317] Koha::Biblio->host_items fails with search_ordered()

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36317 --- Comment #10 from Fridolin Somers <fridolin.somers@biblibre.com> --- Working on this I learned that DBIx combines several searches into one : Koha::Items->search( { itemnumber => 123 } )->search( {}, { join => 'branchtransfers' } ); Will give only one SQL query : SELECT * FROM items JOIN branchtransfers USING itemnumber WHERE itemnumber='123' So we should always use explicit "me" : Koha::Items->search( { "me.itemnumber" => 123 } )->search( {}, { join => 'branchtransfers' } ); -- You are receiving this mail because: You are watching all bug changes.