Bug 38692

Summary: Item search results table filters do not match date display preference
Product: Koha Reporter: Andrew Fuerste-Henry <andrew>
Component: SearchingAssignee: Bugs List <koha-bugs>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: normal    
Priority: P5 - low    
Version: Main   
Hardware: All   
OS: All   
GIT URL: Change sponsored?: ---
Patch complexity: --- Documentation contact:
Documentation submission: Text to go in the release notes:
Version(s) released in:
Circulation function:

Description Andrew Fuerste-Henry 2024-12-12 17:47:22 UTC
When looking at results in item search, there are filters at the top of each column. For columns containing dates, the filter always searches on ISO format (YYYY-MM-DD), but the data will display following the DateFormat system preference.

So your item may show a value of "12/12/2024," but it won't be shown in your results if you enter "12/12/2024" as a filter, only if you enter "2024-12-12"

We could put a datepicker on the filter search field?
Comment 1 Katrin Fischer 2024-12-12 19:30:46 UTC
We could, but there is a downside: You can't do a truncated search with the date widget. Right now you can probably enter just the year or year and month in ISO format.
Comment 2 Andrew Fuerste-Henry 2024-12-12 20:20:08 UTC
(In reply to Katrin Fischer from comment #1)
> We could, but there is a downside: You can't do a truncated search with the
> date widget. Right now you can probably enter just the year or year and
> month in ISO format.

Good point! You're correct that currently you can enter something like "2024-12" to get everything in December 2024, or "-12-" to get everything in any December.