From f940cf491e530906758716f1adc3f5e6a8697b74 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Wed, 29 Oct 2014 17:05:48 -0400 Subject: [PATCH] kmain-168 - sort checked out items original ticket KCM-17 modified: openils/conf/fm_IDL.xml (cherry picked from commit b4f413dcf9592c321cadc024c427e5c931645c28) Cross-port: 0811348 Conflicts: Open-ILS/examples/fm_IDL.xml --- Open-ILS/examples/fm_IDL.xml | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/Open-ILS/examples/fm_IDL.xml b/Open-ILS/examples/fm_IDL.xml index 2021f9564c..cce74fd9de 100644 --- a/Open-ILS/examples/fm_IDL.xml +++ b/Open-ILS/examples/fm_IDL.xml @@ -4558,8 +4558,10 @@ 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 (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 + FROM (SELECT usr, fine_interval, due_date, stop_fines, xact_finish, id, checkin_time + FROM action.circulation + WHERE checkin_time IS NULL + ORDER BY due_date ASC) AS sorted_ac GROUP BY 1 ]]> -- 2.11.0