[Koha] SQL help?

Kerrie Stevens kerrie.stevens at ac.edu.au
Wed May 27 12:24:30 NZST 2020


Every year, we need to confirm graduating students have no outstanding loans so they can graduate. And every year I think I must ask for some help in doing it more efficiently than searching borrower numbers one by one...
I'd like to be able to copy & paste a number of borrower numbers into search box and get back a table showing those with outstanding loans:
(borrower number, name, and number of current loans)
Can cutting & pasting or searching on multiple borrower numbers be done in SQL reports?
This is way beyond my basic level of SQL understanding, so any advice/assistance would be greatly appreciated.

Thank you and have a great day wherever you may be!


Kerrie Stevens  AALIA(CP), MAppSci(LibMgt), BBus(Info&LibMgt)
Director of Library Services, Alphacrucis College
Librarian - Melbourne Campus
HDR Liaison Librarian


More information about the Koha mailing list