* anjoze (joseanjos@gmail.com) wrote:
Hi again, When I try to checkout an Item to a suspended Patron I receive the message saying: Patron has had overdue items and is blocked for XX day(s). If I try to checkout again on the next day, it will show the same number of days. Until the end of the suspended period it shows the same number of days! So, if a few days later that Patron ask me how many days left, I can't tell him :( Is there a way to show the suspension remaining days? Or Is it possible to build a report with that info? Thank you very much, JA
Hi JA If you are running 3.4.x or 3.6.x then yes, you can find that information in the debarred column in the borrowers table. It stores the date of when the suspension ends, so you could do a report like this SELECT debarred FROM borrowers WHERE cardnumber = <<cardnumber>> Then when you run it, it will prompt you for a cardnumber if you enter that you get the date the person is suspended until. Or you could do something like SELECT firstname,lastname,cardnumber,debarred FROM borrowers WHERE debarred IS NOT NULL Which will get you a list of them all. Also, you might like to look on http://bugs.koha-community.org and file an enhancement request to get the date suspended to showing on the borrower record, if a request doesn't already exist. Also, I haven't checked the latest version, it may show the date already Chris
-------------------------------------------
View this message in context: Show suspension days left Sent from the Koha-general mailing list archive at Nabble.com.
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand