Bug 35051 - Reservations Notification for return shelf
Summary: Reservations Notification for return shelf
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Notices (show other bugs)
Version: unspecified
Hardware: All All
: P5 - low enhancement (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-10-13 14:28 UTC by Mathias Hein
Modified: 2023-10-13 15:19 UTC (History)
0 users

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Mathias Hein 2023-10-13 14:28:12 UTC
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.
Comment 1 Katrin Fischer 2023-10-13 14:36:32 UTC
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.
Comment 2 Mathias Hein 2023-10-13 15:07:04 UTC
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.
Comment 3 Katrin Fischer 2023-10-13 15:19:27 UTC
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.