Bug 1825 - Hold awaiting pickup seems incorrect.
Summary: Hold awaiting pickup seems incorrect.
Alias: None
Product: Koha
Classification: Unclassified
Component: Circulation (show other bugs)
Version: rel_3_0
Hardware: PC All
: P3 blocker (vote)
Assignee: Galen Charlton
QA Contact:
Depends on:
Reported: 2008-02-10 08:48 UTC by Chris Cormack
Modified: 2019-06-27 09:24 UTC (History)
0 users

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Note You need to log in before you can comment on or make changes to this bug.
Description Chris Cormack 2010-05-21 00:35:01 UTC

---- Reported by drdrulm@yahoo.com 2008-02-10 08:48:52 ----

Does not seem correct. This looks like a list that can be generated by new reserves. This may be a new table?

A new table is not required and could cause difficulty. 

If anything on the reserve shelf is needed, then the status of the hold can be checked for consigned as you know.

Again, the main point of a report like this is to check patrons who *just* had a reserve put on the reserve shelf either yesterday or perhaps in the morning. Then the list is used to call / email patrons to inform them about the new hold that can be picked up.

This report is in the mess of PHP I gave to Josh. It is working well, and requires no other tables, just SQL and some logic.

Neither the 
#  Holds to pull
# Holds awaiting pickup
reports will work for us in their current states in Koha3. 

I state this with urgency as it is a fairly important part of the reserve process.

There is one additional short report which is reserves that must be taken off the reserve shelf and checked back in. Either they will take a new reserve or be put on a re-shelving cart. 

These 3 reports are going to be crucial for larger libraries. 
1. Daily pull lists (available only-used check out + status)
2. Daily call lists---who just went onto the reserve shelf today/yesterday
3. canceled reserve list, pull off from reserve shelf and check-in

Can you use my PHP scripts? I have not delved into the Koha 3 API's yet, but since my reports are all read access on the database, could they be used and modified slightly for Perl. Something is going to need to be done as the reserves are really important. I know I have bellowed about other important fixes before (item-type xxx - remember), and this will be almost up there with that for soon to go-livers.

---- Additional Comments From jmf@liblime.com 2008-03-04 03:13:11 ----

assigning to Galen, marking as blocker

---- Additional Comments From joe.atzberger@liblime.com 2008-05-30 19:41:51 ----

Josh, can you attach the PHP?

---- Additional Comments From paul.poulain@biblibre.com 2008-06-05 06:06:42 ----

joshua, is this bug related to the discussion we had on #irc about the way US large libraries deal with hold ? and this resulted in circ/view_holdsqueue.pl ?

---- Additional Comments From drdrulm@yahoo.com 2008-06-09 12:33:28 ----

(In reply to comment #1)
> assigning to Galen, marking as blocker
The code I submitted for Open Reserves should solve this. I believe this is resolved. 

---- Additional Comments From gmcharlt@gmail.com 2008-06-09 12:37:09 ----

Marking resolved per Darrell.

--- Bug imported by chris@bigballofwax.co.nz 2010-05-21 00:35 UTC  ---

This bug was previously known as _bug_ 1825 at http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=1825

Actual time not defined. Setting to 0.0
The original reporter of this bug does not have
   an account here. Reassigning to the person who moved
   it here: chris@bigballofwax.co.nz.
   Previous reporter was drdrulm@yahoo.com.
CC member jmf@liblime.com does not have an account here