From ac318a4b7a613c524e9d43028580aafe75f69917 Mon Sep 17 00:00:00 2001 From: blake Date: Fri, 10 Apr 2015 14:29:08 -0500 Subject: [PATCH 1/1] LP1424646 Paid-For Long Overdue Items Still Appear in "Other/Special Circulations" Window Edited the query inside the fm_IDL.xml file Signed-off-by: blake Signed-off-by: Chris Sharp Signed-off-by: Jason Stephenson --- Open-ILS/examples/fm_IDL.xml | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/examples/fm_IDL.xml b/Open-ILS/examples/fm_IDL.xml index 271992458b..b847d16b8f 100644 --- a/Open-ILS/examples/fm_IDL.xml +++ b/Open-ILS/examples/fm_IDL.xml @@ -3883,7 +3883,7 @@ SELECT usr, SUM( CASE WHEN (xact_finish IS NULL AND stop_fines = 'LOST') THEN 1 ELSE 0 END) AS lost, SUM( CASE WHEN stop_fines = 'CLAIMSRETURNED' THEN 1 ELSE 0 END) AS claims_returned, - SUM( CASE WHEN stop_fines = 'LONGOVERDUE' THEN 1 ELSE 0 END) AS long_overdue + SUM( CASE WHEN (xact_finish IS NULL AND stop_fines = 'LONGOVERDUE') THEN 1 ELSE 0 END) AS long_overdue FROM action.circulation WHERE checkin_time IS NULL GROUP BY 1 @@ -3925,7 +3925,7 @@ SELECT usr, STRING_AGG( CASE WHEN (xact_finish IS NULL AND stop_fines = 'LOST') THEN id::TEXT ELSE '0' END,',') AS lost, STRING_AGG( CASE WHEN stop_fines = 'CLAIMSRETURNED' THEN id::TEXT ELSE '0' END,',') AS claims_returned, - STRING_AGG( CASE WHEN stop_fines = 'LONGOVERDUE' THEN id::TEXT ELSE '0' END,',') AS long_overdue + STRING_AGG( CASE WHEN (xact_finish IS NULL AND stop_fines = 'LONGOVERDUE') THEN id::TEXT ELSE '0' END,',') AS long_overdue FROM action.circulation WHERE checkin_time IS NULL GROUP BY 1 -- 2.43.2