From 43244a753fa52d96f1c4ea8b5a2c51cf7e28f562 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Fri, 22 Feb 2019 12:24:58 -0800 Subject: [PATCH] JBAS-2196 Staff browse includes transcendant bibs Signed-off-by: Bill Erickson --- KCLS/sql/schema/deploy/2.12-3.2-db-upgrade-schema.sql | 5 ++++- 1 file changed, 4 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 7028932922..5bb318fb54 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 @@ -6884,7 +6884,10 @@ BEGIN row_number := -1; END IF; - IF NOT staff THEN + IF STAFF THEN + -- include ransendant bibs in staff browse + SELECT asset.bib_source_default() || '|' INTO b_tests; + ELSE SELECT x.c_attrs, x.b_attrs INTO c_tests, b_tests FROM asset.patron_default_visibility_mask() x; END IF; -- 2.11.0