From 4b1b36f636b9d6df9592f9c647d26ce6b0aa00bd Mon Sep 17 00:00:00 2001 From: miker Date: Thu, 4 Jun 2009 00:00:57 +0000 Subject: [PATCH] do not use Located URIs for record inclusion when a copy location filter is requested git-svn-id: svn://svn.open-ils.org/ILS/trunk@13312 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/300.schema.staged_search.sql | 1 + 1 file changed, 1 insertion(+) diff --git a/Open-ILS/src/sql/Pg/300.schema.staged_search.sql b/Open-ILS/src/sql/Pg/300.schema.staged_search.sql index 39e814388a..30ef658c38 100644 --- a/Open-ILS/src/sql/Pg/300.schema.staged_search.sql +++ b/Open-ILS/src/sql/Pg/300.schema.staged_search.sql @@ -430,6 +430,7 @@ BEGIN WHERE NOT cn.deleted AND cn.label = '##URI##' AND uri.active + AND ( param_locations IS NULL OR array_upper(param_locations, 1) IS NULL ) AND cn.record IN ( SELECT * FROM search.explode_array( core_result.records ) ) AND cn.owning_lib IN ( SELECT * FROM search.explode_array( search_org_list ) ) LIMIT 1; -- 2.11.0