https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42984

--- Comment #5 from Brendan Lawlor <[email protected]> ---
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.
_______________________________________________
Koha-bugs mailing list -- [email protected]
To unsubscribe send an email to [email protected]
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to