From e715012c951cf24b8af3daf1af31c6a2bad28503 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Thu, 11 Jan 2018 12:28:47 -0500 Subject: [PATCH] JBAS-1929 Expand mattype filtered browse bounds Look farther and wider for matching browse records when filtering by mattype to improve likelihood of finding a full page of results. Signed-off-by: Bill Erickson --- KCLS/sql/schema/deploy/browse-mattype-filter.sql | 16 +++++++++++++++- 1 file changed, 15 insertions(+), 1 deletion(-) diff --git a/KCLS/sql/schema/deploy/browse-mattype-filter.sql b/KCLS/sql/schema/deploy/browse-mattype-filter.sql index af17020f1b..1cb8f734b0 100644 --- a/KCLS/sql/schema/deploy/browse-mattype-filter.sql +++ b/KCLS/sql/schema/deploy/browse-mattype-filter.sql @@ -18,6 +18,7 @@ AS $FUNK$ DECLARE v_bound_lower TEXT; v_bound_upper TEXT; + v_bound_multiplier INT := 1; core_query TEXT; back_query TEXT; forward_query TEXT; @@ -95,7 +96,20 @@ BEGIN RETURN; END IF; - select bound_lower, bound_upper into v_bound_lower, v_bound_upper from metabib.browse_table_bounds(search_class,public.replace_ampersand(pivot_sort_value),result_limit); + IF item_type IS NOT NULL THEN + -- JBAS-1929 Expand the browse search range when using an item_type + -- filter to increase likelihood of finding a full page of results + -- for very low-hit queries. + v_bound_multiplier = 1000; + END IF; + + SELECT bound_lower, bound_upper + INTO v_bound_lower, v_bound_upper + FROM metabib.browse_table_bounds( + search_class, + public.replace_ampersand(pivot_sort_value), + result_limit * v_bound_multiplier + ); -- Transform the context_loc_group argument (if any) (logc at the -- TPAC layer) into a form we'll be able to use. -- 2.11.0