[Bug 19749] New: Report who show all the reservations
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19749 Bug ID: 19749 Summary: Report who show all the reservations Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Circulation Assignee: koha-bugs@lists.koha-community.org Reporter: patrick.robitaille@collecto.ca QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com, kyle.m.hall@gmail.com 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. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19749 --- Comment #1 from Owen Leonard <oleonard@myacpl.org> --- Does the "Holds to pull" report (circ/pendingreserves.pl) not satisfy this request? -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19749 Lisette <lisetteslatah@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |lisetteslatah@gmail.com --- Comment #2 from Lisette <lisetteslatah@gmail.com> --- (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 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19749 Magnus Enger <magnus@libriotech.no> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |magnus@libriotech.no --- Comment #3 from Magnus Enger <magnus@libriotech.no> --- Could this report do the job? https://wiki.koha-community.org/wiki/SQL_Reports_Library#Unfilled_Holds -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19749 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |katrin.fischer@bsz-bw.de Summary|Report who show all the |Report to show all holds |reservations |placed independent on items | |being available to pull -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19749 --- Comment #4 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- 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? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
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.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19749 Marjorie Barry-Vila <marjorie.barry-vila@collecto.ca> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |marjorie.barry-vila@collect | |o.ca -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19749 Niamh Walker-Headon <Niamh.WalkerHeadon@hse.ie> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |Niamh.WalkerHeadon@hse.ie -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19749 Agnes Rivers-Moore <arm@hanover.ca> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |arm@hanover.ca -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19749 --- Comment #6 from Marjorie Barry-Vila <marjorie.barry-vila@collecto.ca> --- +1 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org