From ed033ec5614400182f9f8fb5b7ee15c9e0945e5f Mon Sep 17 00:00:00 2001
From: miker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Date: Thu, 22 Jul 2010 01:05:18 +0000
Subject: [PATCH] backport of r17007: retain the indicators on located uri 856
 merge during asset merge

git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_1_6@17009 dcc99617-32d9-48b4-a31d-7c20da2025e4
---
 Open-ILS/src/sql/Pg/999.functions.global.sql | 9 +++++++--
 1 file changed, 7 insertions(+), 2 deletions(-)

diff --git a/Open-ILS/src/sql/Pg/999.functions.global.sql b/Open-ILS/src/sql/Pg/999.functions.global.sql
index 1fe4bedf21..c6d8792884 100644
--- a/Open-ILS/src/sql/Pg/999.functions.global.sql
+++ b/Open-ILS/src/sql/Pg/999.functions.global.sql
@@ -242,7 +242,10 @@ BEGIN
                 ) as t(i int,c text);
     
         FOR i IN 1 .. counter LOOP
-            SELECT  '<datafield xmlns="http://www.loc.gov/MARC21/slim" tag="856">' ||
+            SELECT  '<datafield xmlns="http://www.loc.gov/MARC21/slim"' || 
+			' tag="856"' ||
+			' ind1="' || FIRST(ind1) || '"'  ||
+			' ind2="' || FIRST(ind2) || '">' ||
                         array_to_string(
                             array_accum(
                                 '<subfield code="' || subfield || '">' ||
@@ -259,10 +262,12 @@ BEGIN
                         'id',
                         'marc',
                         'biblio.record_entry',
+                        '//*[@tag="856"][position()=' || i || ']/@ind1|' ||
+                        '//*[@tag="856"][position()=' || i || ']/@ind2|' ||
                         '//*[@tag="856"][position()=' || i || ']/*/@code|' ||
                         '//*[@tag="856"][position()=' || i || ']/*[@code]',
                         'id=' || source_record
-                    ) as t(id int,subfield text,data text);
+                    ) as t(id int,ind1 text, ind2 text,subfield text,data text);
 
             uri_text := uri_text || uri_datafield;
         END LOOP;
-- 
2.11.0