Bug 41085 - Date filters use the syntax stored in database.
Summary: Date filters use the syntax stored in database.
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: REST API (show other bugs)
Version: Main
Hardware: All All
: P5 - low enhancement
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-10-23 13:50 UTC by Baptiste Wojtkowski (bwoj)
Modified: 2025-10-23 13:50 UTC (History)
1 user (show)

See Also:
GIT URL:
Initiative type: ---
Sponsorship status: ---
Crowdfunding goal: 0
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Baptiste Wojtkowski (bwoj) 2025-10-23 13:50:21 UTC
Filters used for date  in datatables are not inituitive for users since they compare date as stored in the database. 

For example, in fr, date use to be written DD/MM/YYYY, so users tend to write DD/MM in filters and find nothing. They must have written MM-DD which is barely impossible for them to guess.

Steps to reproduce :
1 - Go on a biblio record
2 - Activate filters
3 - On Date accessionned, copy/paste any field -> it will return nothing.
4 - Write the date in the format YYYY-MM-DD -> it will work

Note: I did put this in REST API but it is related to anything that calls it, if you have a better idea on where we should put this, feel free :)