Hi, we are considering switching to Koha from OCLC for our library. In the future, we would like to set up a return shelf where users can also automatically check in their media at the self-checkout and place them on an adjacent shelf. Currently, however, there is no printout of possible reservations when returning media, so it would be beneficial to receive a notification on the Koha dashboard when someone has returned a reserved medium to the return shelf. This notification should be visually prominent so that we can promptly retrieve the item from the designated shelf and place it in a convenient location for users to pick up. This feature is currently missing and we would currently need to physically touch all items to check if a returned item is being held. This would be a valuable addition.
The mailing list is usually a good starting point to discuss workflows like this. I think we might already have what you need, maybe: If you are using self checks that communicate via SIP2 there is the HoldsNeedProcessingSIP system preference. If activated, holds returned at the self check will not immediately be set to waiting, but remain in a processing status that you can use to find them via a report. The JSON API for reports can then be used with a little jQuery to display the number of holds in this status anywhere you want in Koha basically. Or you could just place a link to the report somewhere using HTML customizations. The processing status requires another checkin, that then sets the item to waiting and alerts the patron who has placed the hold. Depending on your equipment/supplier you can also find out about on hold items via SIP and use this to inform the user about a separate location the item should be placed in.
What is the name of the report or how would it have to be created and how would it be specified there? Maybe I can test this in a demo to see if it works technically. But the chosen approach sounds good.
The report would be written with SQL with the columns you want to display and added to the "Saved reports". Have a look at the reports module - it's super useful. It could look a bit like this: select (select title from biblio bi where bi.biblionumber = i.biblionumber) as Titel, i.itemcallnumber as Signatur, i.barcode AS Barcode, r.borrowernumber AS Benutzernummer, r.reservedate AS Vormerkdatum, r.biblionumber AS Titelsatznummer, r.timestamp AS Zeitstempel from items i, reserves r where r.found = 'P' and i.biblionumber = r.biblionumber order by r.timestamp DESC The interesting bit here is the 'where reserves.found = "P"' If you go the easier route, a link could be added using the IntranetmainUserblock or IntranetNav system preferences.