From 626709b4dbedeb4b6333fda97eb9675afbb6673a Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Mon, 20 May 2019 15:49:25 +0000 Subject: [PATCH] JBAS-2285 Browse 'sees' include all heading purposes Signed-off-by: Bill Erickson --- KCLS/sql/schema/deploy/2.12-3.2-db-upgrade-schema.sql | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) diff --git a/KCLS/sql/schema/deploy/2.12-3.2-db-upgrade-schema.sql b/KCLS/sql/schema/deploy/2.12-3.2-db-upgrade-schema.sql index 1ff03534e8..8d31a52e1e 100644 --- a/KCLS/sql/schema/deploy/2.12-3.2-db-upgrade-schema.sql +++ b/KCLS/sql/schema/deploy/2.12-3.2-db-upgrade-schema.sql @@ -6970,7 +6970,11 @@ BEGIN ) JOIN authority.heading_field ahf ON (ahf.id = acsaf.heading_field) WHERE mbeshm.entry = rec.id - AND ahf.heading_purpose = 'variant'; + -- KCLS JBAS-2285 + -- For reasons that are not yet entirely clear to me, + -- KCLS does not want the 'variant' limitation here. + --AND ahf.heading_purpose = 'variant' + ; END IF; -- 2.11.0