From 59fa7d1b6df7453b68d0da218220c902f5ec0fcd 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..10ac1d6206 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 acsaf WHERE acsaf.control_set = cset AND acsaf.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.43.2