[Bug 1707] Search for patron '%' returns all results
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1707 --- Comment #7 from M. Tompsett <mtompset@hotmail.com> --- Comment on attachment 57068 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=57068 Bug 1707: Do not return more than 100 patrons matching the attributes search Review of attachment 57068: --> (https://bugs.koha-community.org/bugzilla3/page.cgi?id=splinter.html&bug=1707&attachment=57068) ----------------------------------------------------------------- ::: C4/Members/Attributes.pm @@ +152,4 @@
JOIN borrower_attribute_types USING (code) WHERE staff_searchable = 1 AND (} . join (" OR ", map "attribute like ?", @$filter) .qq{)}; + $query .= q{ LIMIT ?} if $limit;
LIMIT is a MySQLism. Perhaps DBIx would be a good way to get around this? Not that I know how to do it, but this looks like a good place to start: http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/ResultSet.pm#rows -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org