Bug 19749 - Report to show all holds placed independent on items being available to pull
Summary: Report to show all holds placed independent on items being available to pull
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Circulation (show other bugs)
Version: unspecified
Hardware: All All
: P5 - low enhancement (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-12-05 14:37 UTC by Patrick Robitaille
Modified: 2022-02-24 18:39 UTC (History)
9 users (show)

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 Patrick Robitaille 2017-12-05 14:37:20 UTC
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.
Comment 1 Owen Leonard 2017-12-05 16:43:10 UTC
Does the "Holds to pull" report (circ/pendingreserves.pl) not satisfy this request?
Comment 2 Lisette Scheer 2017-12-07 22:39:26 UTC
(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
Comment 3 Magnus Enger 2018-03-01 19:06:44 UTC
Could this report do the job? 
https://wiki.koha-community.org/wiki/SQL_Reports_Library#Unfilled_Holds
Comment 4 Katrin Fischer 2018-03-30 13:14:44 UTC
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?
Comment 5 SiobhanC 2018-09-20 15:49:19 UTC
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
Comment 6 Marjorie Barry-Vila 2022-02-24 18:39:20 UTC
+1