[Koha-bugs] [Bug 32559] Support formatted date for column filtering (DT)

[bugzilla-daemon at bugs.koha-community.org]

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

Martin Renvoize <martin.renvoize at ptfs-europe.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
 Attachment #145094|0                           |1
        is obsolete|                            |

--- Comment #18 from Martin Renvoize <martin.renvoize at ptfs-europe.com> ---
Created attachment 153845
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=153845&action=edit
Bug 32559: Add support for formatted date when filtering on a column

When dates are displayed formatted (following the dateformat syspref)
in a DataTable table and that there is a filter for the column, we should
filter correctly the data.

Test plan:
Assuming dateformat is set to metric
Go to the main patron search, search for all patrons (don't provide a
search term)
In the "date of birth" column filter, enter "1958", notice that you see
Henry
Search using an iso formatted date 1958-05-30
Search using a metric formatted date 30/05/1958

Note that:
- it's also working for "Expires on" on the same table. We may want to
adjust other tables that are using the DT REST API wrapper and the
column filters
- You need to search for the full formatted date to make it work.
"30/05" won't work.

Signed-off-by: Lucas Gass <lucas at bywatersolutions.com>

Signed-off-by: Kyle M Hall <kyle at bywatersolutions.com>

-- 
You are receiving this mail because:
You are watching all bug changes.