From 8b988e9da676b2b65b20c503197112a8ccef8d7a 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.11.0