From f513ea3be60ffc84cd767f8c9be05fdb6f7b43e3 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 0e9f710bab..9bd303967c 100644 --- a/Open-ILS/examples/fm_IDL.xml +++ b/Open-ILS/examples/fm_IDL.xml @@ -10278,7 +10278,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.43.2