https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11983
Nick Clemens <n...@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Failed QA --- Comment #20 from Nick Clemens <n...@bywatersolutions.com> --- Hi Martin, Sorry, I should have read the proposed language closer - pending_checkouts is confusing, I think it can just be 'checkouts' filter_by_has_checkouts I wonder about the methods for filtering Why do you search issues for borrowernumber, then use an in? Would it be simpler to use a single query? I think it is clearer to do something like: $self->search("issues.borrowernumber" => { -not => undef } },{join=>"issues"}); Later for housebound_choosers we do a search related to housebound_roles, then another to borrowernumber - this works, but it comes out as "FROM borrowers JOIN housebound_role JOIN borrowers" -Nick -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/