From b08055dc8edc0fa2d2a0448288502f6f57aa41fe Mon Sep 17 00:00:00 2001 From: miker Date: Mon, 5 Feb 2007 20:53:25 +0000 Subject: [PATCH] try this git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_1_0@6891 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/actor.pm | 4 +++- 1 file changed, 3 insertions(+), 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 b1e618beb5..4badd171ea 100644 --- a/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/actor.pm +++ b/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/actor.pm @@ -434,7 +434,9 @@ sub patron_search { my $limit = shift || 1000; my $sort = shift; my $inactive = shift; + $sort = ['family_name','first_given_name'] unless ($$sort[0]); + push @$sort,'id'; # group 0 = user # group 1 = address @@ -520,7 +522,7 @@ sub patron_search { } $select = <<" SQL"; - SELECT DISTINCT $distinct_list, users.id + SELECT DISTINCT $distinct_list FROM $u_table AS users JOIN ($select) AS search USING (id) -- 2.11.0