From 62d124d2b08fb61f80722d8e6d345b36916ec96c Mon Sep 17 00:00:00 2001 From: Steven Callender Date: Thu, 13 Mar 2014 13:34:23 -0400 Subject: [PATCH] Removed deleted call numbers from the search results to properly show copy count. Signed-off-by: Steven Callender --- Open-ILS/examples/fm_IDL.xml | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/examples/fm_IDL.xml b/Open-ILS/examples/fm_IDL.xml index adfcd2eb15..5a04d16e14 100644 --- a/Open-ILS/examples/fm_IDL.xml +++ b/Open-ILS/examples/fm_IDL.xml @@ -10144,7 +10144,7 @@ SELECT usr, SELECT (SELECT id FROM biblio.record_entry - WHERE id = (SELECT record FROM asset.call_number WHERE id = call_number) + WHERE id = (SELECT record FROM asset.call_number WHERE id = call_number and deleted is false) ) AS "bre", COUNT(*) AS "copy_count" FROM asset.copy -- 2.11.0