From ecc5958e5f6187f980b11be05e14d6f0a7f08da5 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 Signed-off-by: Jason Stephenson --- 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..6a90e121c2 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 authority.control_set_authority_field.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