[Koha-bugs] [Bug 19749] Report to show all holds placed independent on items being available to pull

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19749

SiobhanC <siobhancottam at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |siobhancottam at gmail.com

--- Comment #5 from SiobhanC <siobhancottam at gmail.com> ---
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

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.