From 83cd545d2820273b97a4876c7bffbefccf2930fb Mon Sep 17 00:00:00 2001
From: miker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Date: Mon, 27 Feb 2006 21:18:17 +0000
Subject: [PATCH] fixing single class sortable search

git-svn-id: svn://svn.open-ils.org/ILS/trunk@3207 dcc99617-32d9-48b4-a31d-7c20da2025e4
---
 .../Application/Storage/Publisher/metabib.pm    | 17 +++++++++--------
 1 file changed, 9 insertions(+), 8 deletions(-)

diff --git a/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/metabib.pm b/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/metabib.pm
index 0c9bd9b498..a87d504a43 100644
--- a/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/metabib.pm
+++ b/Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/metabib.pm
@@ -1573,33 +1573,34 @@ sub postfilter_Z_search_class_fts {
 	my $rank = $relevance;
 	if (lc($sort) eq 'pubdate') {
 		$rank = <<"		RANK";
-			( FIRST((
-				SELECT	COALESCE(SUBSTRING(frp.value FROM '\\\\d+'),'9999')::INT
+			(
+				SELECT	FIRST(COALESCE(SUBSTRING(frp.value FROM '\\\\d+'),'9999')::INT)
 				  FROM	$metabib_full_rec frp
 				  WHERE	frp.record = f.source
 				  	AND frp.tag = '260'
 					AND frp.subfield = 'c'
-			)) )
+			)
 		RANK
 	} elsif (lc($sort) eq 'title') {
 		$rank = <<"		RANK";
-			( FIRST((
-				SELECT	COALESCE(LTRIM(SUBSTR( frt.value, frt.ind2::text::int )),'zzzzzzzz')
+			(
+				SELECT	FIRST(COALESCE(LTRIM(SUBSTR( frt.value, frt.ind2::text::int )),'zzzzzzzz'))
 				  FROM	$metabib_full_rec frt
 				  WHERE	frt.record = f.source
 				  	AND frt.tag = '245'
 					AND frt.subfield = 'a'
-			)) )
+			)
 		RANK
 	} elsif (lc($sort) eq 'author') {
 		$rank = <<"		RANK";
-			( FIRST((
+			( FIRST ((
 				SELECT	COALESCE(LTRIM(fra.value),'zzzzzzzz')
 				  FROM	$metabib_full_rec fra
 				  WHERE	fra.record = f.source
 				  	AND fra.tag LIKE '1%'
 					AND fra.subfield = 'a'
-					ORDER BY fra.tag::text::int
+				  ORDER BY fra.tag::text::int
+				  LIMIT 1
 			)) )
 		RANK
 	} else {
-- 
2.43.2