[Evergreen-general] Volume and Copy level holds are missing from View Holds tab

[Elaine Hardy]

We are seeing that the holds displayed multiple times. THere are just over
460 in reality

J. Elaine Hardy, PINES and Collaborative Projects Manager
------------------------------

Georgia Public Library Service

2872 Woodcock Blvd., Suite 250 | Atlanta, GA 30341

(404) 235-7128 | ehardy at 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 4:12 PM Elaine Hardy <ehardy at georgialibraries.org>
wrote:

>
> 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 | ehardy at 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 at 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 at list.evergreen-ils.org
>> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-general
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-general/attachments/20230222/4e81d1b2/attachment-0001.htm>