From 40a043e37a87f4cd77cbe7bddcb1fbfc52574a89 Mon Sep 17 00:00:00 2001 From: Steven Callender Date: Thu, 13 Mar 2014 13:34:23 -0400 Subject: [PATCH] LP#1292129: Removed deleted call numbers from the search results to properly show copy count. The SQL in fm_IDL.xml for setting up the reporter source "Hold/Copy Ratio per Bib" includes deleted call numbers which in turn can give an incorrect copy count. The ratio appears to still be correct because deleted copies are considered in the ratio calculation, but not the copy count that is displayed. Signed-off-by: Steven Callender Signed-off-by: Ben Shum --- 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 bfcb65eacb..2d41507a93 100644 --- a/Open-ILS/examples/fm_IDL.xml +++ b/Open-ILS/examples/fm_IDL.xml @@ -10147,7 +10147,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