From 514dd08106e3a30540b09259da4bb0e921b7470c Mon Sep 17 00:00:00 2001 From: miker Date: Mon, 5 Feb 2007 01:37:20 +0000 Subject: [PATCH] case insensitive sorting of users git-svn-id: svn://svn.open-ils.org/ILS/trunk@6865 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/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 18b52c20cf..c94f23825a 100644 --- a/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/actor.pm +++ b/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/actor.pm @@ -510,7 +510,7 @@ sub patron_search { return undef; } - my $order_by = join ', ', map { 'users.'. $_ } @$sort; + my $order_by = join ', ', map { 'LOWER(users.'. $_ . ')' } @$sort; my $distinct_list = join ', ', map { 'users.'. (split / /, $_)[0] } @$sort; if ($inactive) { -- 2.11.0