https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17835 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #58565|0 |1 is obsolete| | Attachment #58600|0 |1 is obsolete| | --- Comment #10 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- Created attachment 60033 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=60033&action=edit Bug 17835: Add an additional LEFT JOIN condition using DBIx::Class The previous query was wrong. If an item type did not contain the translation in the interface's language, the ->search_with_localization did not return it at all. What we need is definitely to add a second condition on the join. For reference: http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/Relationship/Base.pm#c... https://blog.afoolishmanifesto.com/posts/dbix-class-parameterized-relationsh... That sounds hacky but seems to be the DBIx::Class path to follow. Bug 17835: follow-up -- You are receiving this mail because: You are watching all bug changes.