Pre-Fetch All Holds Repeats When >10 Holds are Placed

[Gina Monti]

3.11.X and up

I can confirm this is happening on our 3.11.4 server and on the 3.12 community test server.

1) Go to the Angular catalog.
2) Search an item with more than 10 holds (or add some on).
3) Go to "View Holds".
4) Check off "Pre-Fetch All Holds"
5) Observe that when you click from page to page (with 10 showing), the holds repeat.

Below are some screenshots. As you can see in the screenshots, I'm actually on pages 3 and 4 with the same information repeating.

[Gina Monti (gmonti90)]

Page 3

[Gina Monti (gmonti90)]

Page 4

[Jennifer Pringle (jpringle-u)]

On 3.11.1 I'm seeing differences between the initial pages but once I get to the end of my list if I page forward again it repeats (and the row numbers keep increasing).

I looked at a title with 63 holds and I've clicked through so many times I'm now up to 190. So pages 1 through 7 list different holds but page 8 matches page 1 and so on.

Gina, does this match what you're seeing? I'm not sure it's the same or slightly different.

[Gina Monti (gmonti90)]

Hi Jennifer,

I say that is what we are seeing over here, but we haven't tried a record with that many holds before. We do notice that it does replicate the issue only if 'pre-fetch all holds' is checked off.

[Michele Morgan (mmorgan)]

Also seeing this issue in the 3.10.3 Angular staff catalog.

When Pre-Fetch All Holds is selected, once the last full page of holds is reached, clicking the next page button should display a partial grid with the remaining rows, with next page button disabled. Instead, the entire list of holds is retrieved and added to those already viewed. If you page through beyond the total number of holds on the record, then sort the list by hold id, you'll see the duplicates displayed.

My example was a record with 63 holds with the row count of 25 selected. When I clicked to the third page, which should have shown 13 rows, I saw 25. When I sorted by hold id in ascending, then descending order, I observed that the first 50 holds were duplicated and the last 13 were not.

The issue does not appear at all if the number of holds on the record is smaller than the number of rows displayed. In that case the next page option is disabled.