Generating Check-out Items from action_log
Hi My old_issue table is empty as I have deleted it while trying to solve the problem of DBMS auto increment. I am wondering if it is possible to get a list of Checked out books from the action_log table. I am interested in the bibliographic information title, author and the time the book was checked out. Any pointers would be greatly appreciated. -- Kind Regards, Admire Mutsikiwa (Mr) ICT Manager Libraries University of Zimbabwe Tel:+263-4-303276 Mob:+263782476883 “It is easy to dodge our responsibilities, but we cannot dodge the consequences of dodging our responsibilities.” Josiah Charles Stamp
Hi , can you try to check if you have backup for your database here : /var/spool/koha On Tue, May 22, 2018 at 2:53 PM, Mr Mutsikiwa Admire < amutsikiwa@uzlib.uz.ac.zw> wrote:
Hi My old_issue table is empty as I have deleted it while trying to solve the problem of DBMS auto increment. I am wondering if it is possible to get a list of Checked out books from the action_log table. I am interested in the bibliographic information title, author and the time the book was checked out. Any pointers would be greatly appreciated.
--
Kind Regards,
Admire Mutsikiwa (Mr) ICT Manager Libraries University of Zimbabwe Tel:+263-4-303276 Mob:+263782476883
“It is easy to dodge our responsibilities, but we cannot dodge the consequences of dodging our responsibilities.” Josiah Charles Stamp
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- *Karam Qubsi*
Hi! You can try the statistics table. statistics.type will give you 'issues', 'return', etc., just filter it to this two. It has datetime, borrowernumber, itemnumber which you can use in restoring recorda for your issues/old issues. Hth! -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
participants (3)
-
Karam Qubsi -
Mr Mutsikiwa Admire -
schnydszch