From 56ea7eb1463c07b8de5c37a53f6426e774eb47f6 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Thu, 10 Jan 2013 16:35:44 -0500 Subject: [PATCH] Only consider main entry headings for bib overlay Restrict the authority fields we will pull overlay data from to those that do not subordinate themselves to other authority fields. That is, skip see-from/see-also/etc for bib overlay. Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/011.schema.authority.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/011.schema.authority.sql b/Open-ILS/src/sql/Pg/011.schema.authority.sql index 1b150252e3..f0fdde4b87 100644 --- a/Open-ILS/src/sql/Pg/011.schema.authority.sql +++ b/Open-ILS/src/sql/Pg/011.schema.authority.sql @@ -408,7 +408,7 @@ BEGIN )::TEXT; END IF; - FOR main_entry IN SELECT * FROM authority.control_set_authority_field WHERE control_set = cset LOOP + FOR main_entry IN SELECT * FROM authority.control_set_authority_field WHERE control_set = cset AND main_entry IS NULL LOOP auth_field := XPATH('//*[@tag="'||main_entry.tag||'"][1]',source_xml::XML); IF ARRAY_LENGTH(auth_field,1) > 0 THEN FOR bib_field IN SELECT * FROM authority.control_set_bib_field WHERE authority_field = main_entry.id LOOP -- 2.11.0