Summary: | Report to show all holds placed independent on items being available to pull | ||
---|---|---|---|
Product: | Koha | Reporter: | Patrick Robitaille <patrick.robitaille> |
Component: | Circulation | Assignee: | Bugs List <koha-bugs> |
Status: | NEW --- | QA Contact: | Testopia <testopia> |
Severity: | enhancement | ||
Priority: | P5 - low | CC: | arm, gmcharlt, kyle.m.hall, lisettepalouse+koha, magnus, marjorie.barry-vila, Niamh.WalkerHeadon, siobhancottam |
Version: | unspecified | ||
Hardware: | All | ||
OS: | All | ||
Change sponsored?: | --- | Patch complexity: | --- |
Documentation contact: | Documentation submission: | ||
Text to go in the release notes: | Version(s) released in: | ||
Circulation function: |
Description
Patrick Robitaille
2017-12-05 14:37:20 UTC
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 |