https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42500 --- Comment #6 from Kyle M Hall (khall) <kyle@bywatersolutions.com> --- Created attachment 201442 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=201442&action=edit Bug 42500: Update hold ratios page to fetch data via the API The page used to run the hold ratios query and render every matching row, then hand the full table to DataTables to page through in the browser. On larger systems with many holds that means loading the whole result set on every visit. This patch turns the table into a server side DataTable that fetches from the /holds/ratios API, so only one page of rows is loaded at a time. The sidebar form still drives the ratio and date filters; it reloads the page and seeds the table's API request. The libraries, item types, locations and collections come back ready to display, and the title link, item lists and "to order" button are rendered in the browser. Test Plan: 1) Apply this patch 2) Restart all the things! 3) Place several holds on a biblio with fewer items than holds 4) Go to Circulation -> Hold ratios 5) Note the biblio is listed with its hold ratio, libraries, item types and items needed! 6) Change the hold ratio filter and the dates, click Go 7) Note the list updates to match! 8) Sort by Holds, Items, Hold ratio and Items needed 9) Note the sorting works across pages! 10) Reach the page from an acquisitions basket ( with a vendor and basket in the URL ) 11) Note the "N to order" button links into a new order! -- You are receiving this mail because: You are watching all bug changes.