Bugzilla – Attachment 5567 Details for
Bug 6773
CircAutoCompl uses unlimited query
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Signed off Patch (minor revision to text)
0001-Bug-6773-circ-ysearch.pl-is-unlimited.patch (text/plain), 1.76 KB, created by
Ian Walls
on 2011-09-23 13:48:53 UTC
(
hide
)
Description:
Signed off Patch (minor revision to text)
Filename:
MIME Type:
Creator:
Ian Walls
Created:
2011-09-23 13:48:53 UTC
Size:
1.76 KB
patch
obsolete
>From c8b1d79639887baaac493bfddc870462decc56a0 Mon Sep 17 00:00:00 2001 >From: Joy Nelson <joy@bywatersolutions.com> >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 <ian.walls@bywatersolutions.com> >--- > circ/ysearch.pl | 3 ++- > .../en/modules/admin/preferences/circulation.pref | 1 + > 2 files changed, 3 insertions(+), 1 deletions(-) > >diff --git a/circ/ysearch.pl b/circ/ysearch.pl >index 549a547..ce890f5 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 dc821a8..f6324e3 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: >-- >1.7.4.1 >
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 6773
:
5566
| 5567