Hi, The report "Holds queue" don't show all the reservations. It show only the list of reservations made on the "next available items". It would be great to have in the circulation section a report who give the list of all the reservations for itmes on loan. It could be useful for librarys to have acces to a report who show all the reservations in the circulation's module. Patrick.
Does the "Holds to pull" report (circ/pendingreserves.pl) not satisfy this request?
(In reply to Owen Leonard from comment #1) > Does the "Holds to pull" report (circ/pendingreserves.pl) not satisfy this > request? "Holds to pull" only has items on the shelf. I think Patrick is looking for all items on hold even when an item is on loan. Lisette
Could this report do the job? https://wiki.koha-community.org/wiki/SQL_Reports_Library#Unfilled_Holds
We've had libraries asking about this too and have written reports, but if this is a recurring request, a built in report might make sense. Maybe an option on one of the existing ones to also show holds with all items checked out?
Hi, This is something that we requested with our implementation of Koha, because we also keep paper-based reservation information (for now). The report that PTFS and I wrote is: SELECT biblio.title AS 'Title', CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=', biblionumber, '\">Click here</a>' ) AS 'Title link', CONCAT (borrowers.firstname,' ', borrowers.surname) AS 'Name', reserves.reservedate AS 'Date of reservation', reserves.branchcode AS 'Pick up location' FROM reserves JOIN biblio USING (biblionumber) JOIN borrowers USING (borrowernumber) WHERE reserves.reservedate BETWEEN <<Reservation placed between |date>> AND <<and|date>> AND reserves.found IS NULL It's still not quite perfect, as it shows available items too. Siobhan
+1