[Koha-bugs] [Bug 1707] Search for patron '%' returns all results

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1707

--- Comment #7 from M. Tompsett <mtompset at 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.