https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42839
Anneli Österman <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |anneli.osterman@koha-suomi. | |fi --- Comment #1 from Anneli Österman <[email protected]> --- The SIP accounts are recorded in action_logs table and we have used this kind of report to check how many checkouts and returns have been down by certain SIP account: SELECT CONCAT(HOUR(timestamp), ':00-', HOUR(timestamp)+1, ':00') AS 'Hours', sum(IF(action = 'ISSUE', 1, 0)) AS 'Checkouts', sum(IF(action = 'RETURN', 1, 0)) AS 'Returns' FROM action_logs WHERE module = 'CIRCULATION' AND user = <<SIP account's borrowernumber>> AND timestamp BETWEEN <<Starting from|date>> AND <<Ending to|date>> AND action IN ('ISSUE','RETURN') GROUP BY HOUR(timestamp) Nevertheless, I'm all in for improvements. :) -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
