I am seeing both copy and title level holds for Spare in the PINES catalog in the view holds tab.. However, the holds count is wonky . -- 462 but if I page through, there appear to be over 1000.
J. Elaine Hardy, PINES and Collaborative Projects Manager ------------------------------ Georgia Public Library Service 2872 Woodcock Blvd., Suite 250 | Atlanta, GA 30341 (404) 235-7128 | eha...@georgialibraries.org (404) 548-4241 | Cell <https://www.facebook.com/georgialibraries> <https://www.twitter.com/georgialibs> <https://www.instagram.com/georgialibraries/> Join our email list <http://georgialibraries.org/subscription> for stories of Georgia libraries making an impact in our communities. It does not do to leave a live dragon out of your calculations, if you live near him. *— J.R.R. Tolkien* On Wed, Feb 22, 2023 at 2:26 PM Tina Ji via Evergreen-general < evergreen-general@list.evergreen-ils.org> wrote: > Hi all, > > We are seeing something strange on View Holds tab. It seems happening to > a bib with many holds (over 300). We found only one such bib in our > consortium, i.e. the very hot title: Spare. We wonder whether anyone else > sees it, too, and whether there is a bug. > > One of our libraries noticed that some holds were not displayed on View > Holds tab under the bib, but displayed on Holds tab in the patron's > accounts. > > By comparing the various types of holds we found by a SQL query and those > displayed on View Holds tab, we found some Volumne and Copy level holds are > missing from View Holds tab. > > We compared the holds displayed and not displayed. We did not find > anything special in the non-displayed holds. One thing that seems common is > that the newer (placed more recently) V and C level holds are displayed. > The missed ones seem the older ones. > > In our particular case, out of 14 V level holds, only 4 are displayed; out > of 27 C level holds, 7 are displayed. Re-scoping the pickup library does > not make any difference. Toggling between Pre-Fetch All Holds checkbox > does not make the missing holds show up. > > > Another issue we noticed is that with Pre-fetch all holds checkbox > selected, flipping to next page seems endless. See the attached image. > > > This is the SQL statement to find out the number of holds by hold type: > > select count (*), hold_type from action.hold_request h where cancel_time > is null and fulfillment_time is null and (expire_time>now()::date or > expire_time is null) and ( target=(bib id) or target in (select distinct id > from asset.call_number cn where record =(bib id) ) or target in (select > distinct c.id from asset.copy c, asset.call_number cn where > cn.id=c.call_number > and c.deleted is false and record=(bib id))) group by 2; > > Tina > BC Libraries Coop > _______________________________________________ > Evergreen-general mailing list > Evergreen-general@list.evergreen-ils.org > http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general >
_______________________________________________ Evergreen-general mailing list Evergreen-general@list.evergreen-ils.org http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general