From 53e9e56e281aa086c45907d88cf870f27727f8cc Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Thu, 23 May 2019 18:19:43 +0000 Subject: [PATCH] JBAS-2285 Auth browse prefers lcsh records Signed-off-by: Bill Erickson --- KCLS/sql/schema/deploy/stock-browse-schema.sql | 10 ++++++++-- 1 file changed, 8 insertions(+), 2 deletions(-) diff --git a/KCLS/sql/schema/deploy/stock-browse-schema.sql b/KCLS/sql/schema/deploy/stock-browse-schema.sql index ff36e841cf..2abd7bea6c 100644 --- a/KCLS/sql/schema/deploy/stock-browse-schema.sql +++ b/KCLS/sql/schema/deploy/stock-browse-schema.sql @@ -108,8 +108,14 @@ $FUNK$ AND acsaf.main_entry IS NULL AND NOT are.deleted AND cmf.field_class = search_class - -- assume the largest record is the best as a tie breaker. - ORDER BY LENGTH(are.marc) DESC + ORDER BY + -- favor 'lcsh' headings over other thesauri, + -- falling back to record size as a tie-breaker + CASE + WHEN ash.thesaurus = 'lcsh' THEN 1000000 + ELSE LENGTH(are.marc) + END + DESC LIMIT 1; $FUNK$ LANGUAGE SQL STABLE; -- 2.11.0