From 894799b690ad07e1274ebbcb99f2c874f4daa517 Mon Sep 17 00:00:00 2001
From: miker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Date: Wed, 31 Jan 2007 22:00:46 +0000
Subject: [PATCH] deduplicating paton search results

git-svn-id: svn://svn.open-ils.org/ILS/trunk@6841 dcc99617-32d9-48b4-a31d-7c20da2025e4
---
 Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/actor.pm | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

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 f6f3f72424..709caa16cd 100644
--- a/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/actor.pm
+++ b/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/actor.pm
@@ -496,7 +496,8 @@ sub patron_search {
 		return undef;
 	}
 
-	my $order_by = join ', ', map { 'users.'. $_} @$sort;
+	my $order_by = join ', ', map { 'users.'. $_ } @$sort;
+	my $distinct_list = join ', ', map { 'users.'. (split / /, $_)[0] } @$sort;
 
 	if ($inactive) {
 		$inactive = '';
@@ -505,7 +506,7 @@ sub patron_search {
 	}
 
 	$select = <<"	SQL";
-		SELECT	users.id
+		SELECT	DISTINCT $distinct_list, users.id
 		  FROM	$u_table AS users
 			JOIN ($select) AS search
 		  USING (id)
-- 
2.11.0