[Koha] Table for holds placed

Joe Atzberger ohiocore at gmail.com
Sat Aug 22 13:54:45 NZST 2009


Holds are complicated because there is a temporary table used by the cronjob
to rebuild the holdsqueue (and upgrade priorities downstream after
cancellations, hand off the hold to the next waiting requester, etc.)
--Joe

On Fri, Aug 21, 2009 at 6:13 PM, Kathy Rippel <kdr at ckls.org> wrote:

> Thanks for the information, Nicole, especially the link.
>
> The table you mentioned does NOT do what I was looking for. However,
> after scanning the information at the link you gave me I discovered
> that the Reserves table should do the trick.
>
> I also found some other answers to questions that probably would have
> come up in the future!
>
> Kathy
>
> At 12:09 PM 8/21/2009, Nicole Engard wrote:
> >Kathy,
> >
> >I think it's tmp_holdsqueue
> >
> >
> http://git.koha.org/cgi-bin/gitweb.cgi?p=Koha;a=blob_plain;f=installer/data/mysql/kohastructure.sql;hb=HEAD
> >
> >Nicole
> >
> >On Fri, Aug 21, 2009 at 1:02 PM, Kathy Rippel<kdr at ckls.org> wrote:
> > > Which table stores the information about holds (which patrons have
> > > holds, waiting, etc.)
> > >
> > > I'm trying to make a report but don't seem to find that in the tables
> > > I know about.
> > >
> > > Kathy
> > > Kathleen D. Rippel
> > > Dept. Head/Consultant--Resource Sharing and Access ;
> > > Pathfinder Central (Manager)
> > > Central Kansas Library System
> > > 1409 Williams
> > > Great Bend, KS 67530
> > >
> > > (620-792-4865) phone
> > > (800-362-2642) toll-free, KS
> > > (620-792-5495) fax
> > >
> > > kdr at ckls.org
> > >
> >
> ********************************************************************************************
> > > I'm currently reading: From Our Home to Your Home, by Virginia
> > Docking Rice.
> > > I'm currently listening to: Breaking Dawn, by Stephenie Meyer.
> > >
> > >
> > >
> > >
> > >
> > > _______________________________________________
> > > Koha mailing list
> > > Koha at lists.katipo.co.nz
> > > http://lists.katipo.co.nz/mailman/listinfo/koha
> > >
>
> Kathleen D. Rippel
> Dept. Head/Consultant--Resource Sharing and Access ;
> Pathfinder Central (Manager)
> Central Kansas Library System
> 1409 Williams
> Great Bend, KS 67530
>
> (620-792-4865) phone
> (800-362-2642) toll-free, KS
> (620-792-5495) fax
>
> kdr at ckls.org
>
> ********************************************************************************************
> I'm currently reading: From Our Home to Your Home, by Virginia Docking
> Rice.
> I'm currently listening to: Breaking Dawn, by Stephenie Meyer.
>
>
>
>
>
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20090821/ab5f0b81/attachment.htm 


More information about the Koha mailing list