Hi All, I would like to generate a report based on all the returned books on a specify date Can anyone assist me on my request? This is the screenshot i am referring to the return date http://koha.1045719.n5.nabble.com/file/n4737287/koha.jpg -- View this message in context: http://koha.1045719.n5.nabble.com/Item-Return-Date-tp4737287p4737287.html Sent from the Koha - Discuss mailing list archive at Nabble.com.
Hi all, anyone can assist me? Thank you. -- View this message in context: http://koha.1045719.n5.nabble.com/Item-Return-Date-tp4737287p4744691.html Sent from the Koha - Discuss mailing list archive at Nabble.com.
I would like to generate a report based on all the returned books on a specify date
Returns are tracked in the statistics table, where the 'type' column contains 'return,' and the return date is in the 'datetime' column. I'm not good at efficient SQL, so I won't try to suggest a query that returns user-friendly data from biblio (for instance). You can get more ideas from the SQL reports library: http://wiki.koha-community.org/wiki/SQL_Reports_Library -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org
Hi Owen, You are great..i managed to generate out a report on items that have returned to my library. I really appreciate your help and thank you very much/ -- View this message in context: http://koha.1045719.n5.nabble.com/Item-Return-Date-tp4737287p4753587.html Sent from the Koha - Discuss mailing list archive at Nabble.com.
participants (2)
-
ahtshun83 -
Owen Leonard