From 38ca8d6de18e630751dcae313d66f8546934fb5c Mon Sep 17 00:00:00 2001 From: Joy Nelson Date: Thu, 22 Sep 2011 22:36:48 -0400 Subject: [PATCH] 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 Signed-off-by: Chris Cormack --- circ/ysearch.pl | 3 ++- .../prog/en/modules/admin/preferences/circulation.pref | 1 + 2 files changed, 3 insertions(+), 1 deletion(-) diff --git a/circ/ysearch.pl b/circ/ysearch.pl index 549a5471d0..ce890f5b19 100755 --- 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 dc821a80c2..f6324e3696 100644 --- 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: -- 2.39.5