https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19749 SiobhanC <siobhancottam@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |siobhancottam@gmail.com --- Comment #5 from SiobhanC <siobhancottam@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.