https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42984 --- Comment #5 from Brendan Lawlor <blawlor@clamsnet.org> --- Created attachment 204499 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=204499&action=edit Bug 42984: Fix filtering hold table by date and expiration This patch adds type: "date" and searchable: "true" to the column definitions for Date and Expiration in the holds table. To test: 1. Create some holds on a bib and add different expiration dates 2. Try searching by an expiration date using the displayed date 3. See 'No matching results found' 4. Apply patch and restart all 5. Try step 2 again using the displayed date and iso format 2026-09-19 6. Note: searching by iso supports partial dates like 09-19 but searching by the displayed date only supports exact matches like '09/19/2026' This is because iso dates are in the database and matches with { like: "%" + value + "%" }; Since bug 37542 dayjs uses strict parsing, so only exact matches are supported for displayed dates. Assisted-by: Sonnet 5 (Anthropic) -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.