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.)<br>--Joe<br>
<br><div class="gmail_quote">On Fri, Aug 21, 2009 at 6:13 PM, Kathy Rippel <span dir="ltr"><<a href="mailto:kdr@ckls.org">kdr@ckls.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Thanks for the information, Nicole, especially the link.<br>
<br>
The table you mentioned does NOT do what I was looking for. However,<br>
after scanning the information at the link you gave me I discovered<br>
that the Reserves table should do the trick.<br>
<br>
I also found some other answers to questions that probably would have<br>
come up in the future!<br>
<font color="#888888"><br>
Kathy<br>
</font><div><div></div><div class="h5"><br>
At 12:09 PM 8/21/2009, Nicole Engard wrote:<br>
>Kathy,<br>
><br>
>I think it's tmp_holdsqueue<br>
><br>
><a href="http://git.koha.org/cgi-bin/gitweb.cgi?p=Koha;a=blob_plain;f=installer/data/mysql/kohastructure.sql;hb=HEAD" target="_blank">http://git.koha.org/cgi-bin/gitweb.cgi?p=Koha;a=blob_plain;f=installer/data/mysql/kohastructure.sql;hb=HEAD</a><br>
><br>
>Nicole<br>
><br>
>On Fri, Aug 21, 2009 at 1:02 PM, Kathy Rippel<<a href="mailto:kdr@ckls.org">kdr@ckls.org</a>> wrote:<br>
> > Which table stores the information about holds (which patrons have<br>
> > holds, waiting, etc.)<br>
> ><br>
> > I'm trying to make a report but don't seem to find that in the tables<br>
> > I know about.<br>
> ><br>
> > Kathy<br>
> > Kathleen D. Rippel<br>
> > Dept. Head/Consultant--Resource Sharing and Access ;<br>
> > Pathfinder Central (Manager)<br>
> > Central Kansas Library System<br>
> > 1409 Williams<br>
> > Great Bend, KS 67530<br>
> ><br>
> > (620-792-4865) phone<br>
> > (800-362-2642) toll-free, KS<br>
> > (620-792-5495) fax<br>
> ><br>
> > <a href="mailto:kdr@ckls.org">kdr@ckls.org</a><br>
> ><br>
> ********************************************************************************************<br>
> > I'm currently reading: From Our Home to Your Home, by Virginia<br>
> Docking Rice.<br>
> > I'm currently listening to: Breaking Dawn, by Stephenie Meyer.<br>
> ><br>
> ><br>
> ><br>
> ><br>
> ><br>
> > _______________________________________________<br>
> > Koha mailing list<br>
> > <a href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br>
> > <a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
> ><br>
<br>
Kathleen D. Rippel<br>
Dept. Head/Consultant--Resource Sharing and Access ;<br>
Pathfinder Central (Manager)<br>
Central Kansas Library System<br>
1409 Williams<br>
Great Bend, KS 67530<br>
<br>
(620-792-4865) phone<br>
(800-362-2642) toll-free, KS<br>
(620-792-5495) fax<br>
<br>
<a href="mailto:kdr@ckls.org">kdr@ckls.org</a><br>
********************************************************************************************<br>
I'm currently reading: From Our Home to Your Home, by Virginia Docking Rice.<br>
I'm currently listening to: Breaking Dawn, by Stephenie Meyer.<br>
<br>
<br>
<br>
<br>
<br>
_______________________________________________<br>
Koha mailing list<br>
<a href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br>
<a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
</div></div></blockquote></div><br>