From 1f023b6b4ac489e296c18d222d9c1e1cdb490962 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Thu, 12 Dec 2013 17:08:17 -0500 Subject: [PATCH] evergreen.located_uris() returns a rank, and we should use it Signed-off-by: Mike Rylander Signed-off-by: Jeff Godin --- Open-ILS/src/sql/Pg/990.schema.unapi.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/990.schema.unapi.sql b/Open-ILS/src/sql/Pg/990.schema.unapi.sql index f819c642be..88ef311875 100644 --- a/Open-ILS/src/sql/Pg/990.schema.unapi.sql +++ b/Open-ILS/src/sql/Pg/990.schema.unapi.sql @@ -462,7 +462,7 @@ RETURNS XML AS $F$ FROM evergreen.ranked_volumes($1, $2, $4, $6, $7, $9, $5) AS y UNION ALL -- Located URIs - SELECT unapi.acn(uris.id,'xml','volume',evergreen.array_remove_item_by_value( evergreen.array_remove_item_by_value($5,'holdings_xml'),'bre'), $3, $4, $6, $7, FALSE), 0, name, label_sortkey + SELECT unapi.acn(uris.id,'xml','volume',evergreen.array_remove_item_by_value( evergreen.array_remove_item_by_value($5,'holdings_xml'),'bre'), $3, $4, $6, $7, FALSE), uris.rank, name, label_sortkey FROM evergreen.located_uris($1, $2, $9) AS uris )x) ), -- 2.43.2