From b45bc0bad508560e5dd834304967326f81f65e42 Mon Sep 17 00:00:00 2001 From: Jason Boyer Date: Fri, 18 Oct 2013 10:26:26 -0400 Subject: [PATCH] LP#1241644: Remove xact_finish IS NULL checks from CLAIMSRETURNED and LONGOVERDUE Makes open-ils.actor.user.checked_out(.count) results agree with open-ils.storage.actor.user.checked_out(.count) results. Signed-off-by: Jason Boyer Signed-off-by: Michele Morgan Signed-off-by: Ben Shum --- Open-ILS/examples/fm_IDL.xml | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/Open-ILS/examples/fm_IDL.xml b/Open-ILS/examples/fm_IDL.xml index c91a9b61db..0e9f710bab 100644 --- a/Open-ILS/examples/fm_IDL.xml +++ b/Open-ILS/examples/fm_IDL.xml @@ -3829,8 +3829,8 @@ SELECT usr, ) AS overdue, SUM( CASE WHEN (xact_finish IS NULL AND stop_fines = 'LOST') THEN 1 ELSE 0 END) AS lost, - SUM( CASE WHEN (xact_finish IS NULL AND stop_fines = 'CLAIMSRETURNED') THEN 1 ELSE 0 END) AS claims_returned, - SUM( CASE WHEN (xact_finish IS NULL AND stop_fines = 'LONGOVERDUE') THEN 1 ELSE 0 END) AS long_overdue + 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 FROM action.circulation WHERE checkin_time IS NULL GROUP BY 1 @@ -3871,8 +3871,8 @@ SELECT usr, ,',') AS overdue, STRING_AGG( CASE WHEN (xact_finish IS NULL AND stop_fines = 'LOST') THEN id::TEXT ELSE '0' END,',') AS lost, - STRING_AGG( CASE WHEN (xact_finish IS NULL AND stop_fines = 'CLAIMSRETURNED') THEN id::TEXT ELSE '0' END,',') AS claims_returned, - STRING_AGG( CASE WHEN (xact_finish IS NULL AND stop_fines = 'LONGOVERDUE') THEN id::TEXT ELSE '0' END,',') AS long_overdue + 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 FROM action.circulation WHERE checkin_time IS NULL GROUP BY 1 -- 2.43.2