From a93c5b54d22bf8cf8452620720dee1572ef18a95 Mon Sep 17 00:00:00 2001 From: gmc Date: Thu, 22 Jul 2010 21:37:59 +0000 Subject: [PATCH] bug #608937: make barcode search from main patron search form case-insensitive Signed-off-by: Galen Charlton git-svn-id: svn://svn.open-ils.org/ILS/trunk@17014 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- .../src/perlmods/OpenILS/Application/Storage/Publisher/actor.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/actor.pm b/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/actor.pm index ba0f3bc6e4..cdd11e65fe 100644 --- a/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/actor.pm +++ b/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/actor.pm @@ -658,7 +658,7 @@ sub patron_search { my $card = ''; if ($cv) { - $card = 'JOIN (SELECT DISTINCT usr FROM actor.card WHERE barcode LIKE ?||\'%\') AS card ON (card.usr = users.id)'; + $card = 'JOIN (SELECT DISTINCT usr FROM actor.card WHERE LOWER(barcode) LIKE ?||\'%\') AS card ON (card.usr = users.id)'; unshift(@usrv, $cv); } -- 2.43.2