Bug 6773: circ/ysearch.pl is unlimited

Added a LIMIT 10 to the SQL statement
Edited the circulation.pref stating that autocomplete returns the first 10 results at a time

Signed-off-by: Ian Walls <ian.walls@bywatersolutions.com>
Signed-off-by: Chris Cormack <chrisc@catalyst.net.nz>

diff --git a/circ/ysearch.pl b/circ/ysearch.pl
index 549a547..ce890f5 100755 (executable)
--- a/circ/ysearch.pl
+++ b/circ/ysearch.pl
@@ -47,7 +47,8 @@ my $sql = qq(SELECT surname, firstname, cardnumber, address, city, zipcode, coun
              WHERE surname LIKE ?
              OR firstname LIKE ?
              OR cardnumber LIKE ?
-             ORDER BY surname, firstname);
+             ORDER BY surname, firstname
+             LIMIT 10);
 my $sth = $dbh->prepare( $sql );
 $sth->execute("$query%", "$query%", "$query%");
 

diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref
index dc821a8..f6324e3 100644 (file)
--- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref
+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref
@@ -7,6 +7,7 @@ Circulation:
                   yes: Try
                   no: "Don't try"
             - to guess the patron being entered while typing a patron search on the circulation screen.
+            - Only returns the first 10 results at a time.
         -
             - pref: itemBarcodeInputFilter
               choices: