From 4d0dae6ee876830cb87ee393a41fcdc478ecc6b0 Mon Sep 17 00:00:00 2001 From: Thomas Berezansky Date: Wed, 6 Jul 2011 12:54:03 -0400 Subject: [PATCH] Allow staff search to find bibs sans copies AKA, no call number OR no call numbers with copies Signed-off-by: Thomas Berezansky Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/300.schema.staged_search.sql | 2 ++ 1 file changed, 2 insertions(+) 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 79de913642..ebea8cd2d5 100644 --- a/Open-ILS/src/sql/Pg/300.schema.staged_search.sql +++ b/Open-ILS/src/sql/Pg/300.schema.staged_search.sql @@ -283,7 +283,9 @@ BEGIN PERFORM 1 FROM asset.call_number cn + JOIN asset.copy cp ON (cp.call_number = cn.id) WHERE cn.record IN ( SELECT * FROM unnest( core_result.records ) ) + AND NOT cp.deleted LIMIT 1; IF FOUND THEN -- 2.43.2