From 161cb8e92a3c5a5ac2255b0c952f8de0743cdbdd 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 68253f9d8d..90350eea13 100644 --- a/Open-ILS/examples/fm_IDL.xml +++ b/Open-ILS/examples/fm_IDL.xml @@ -10056,7 +10056,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