Declined
Last Updated: 17 Sep 2021 11:25 by ADMIN
John
Created on: 13 Jan 2015 21:06
Category: Grid
Type: Feature Request
5
Kendoui grid date filter "Is equal to" - Make it have a range base on what is input
<pre>
Kendoui grid date filterable "Is equal to" - Make it have a range base on what is input

If you have a date column in a grid and you filter it
and select "Is equal to"
it currently doesn't work very good unless your dates/time
are all on 12:00:00.000 AM

Maybe you could make the filter do this when "Is equal to"

If you select or inputput:

2/22/2004
	It will find the following rows:
	02/22/2004 00:00:00.000 <= datesFound < 02/23/2004 00:00:00.000

2/22/2004 06:
	It will find the following rows:
	02/22/2004 06:00:00.000 <= datesFound < 02/23/2004 07:00:00.000

2/22/2004 06:50
	It will find the following rows:
	02/22/2004 06:50:00.000 <= datesFound < 02/23/2004 07:51:00.000

2/22/2004 06:50:20
	It will find the following rows:
	02/22/2004 06:50:20.000 <= datesFound < 02/23/2004 07:51:21.000

2/22/2004 06:50:20.034
	It will find the following rows:
	02/22/2004 06:50:20.034 <= datesFound < 02/23/2004 07:51:21.035

Maybe have a toggle for (0-12 AM/PM) or (00-23 24 hour clock)
in the datetimepicker with a default setting that can be configured.

Maybe make the datetimepicker have a range for each 
Hour, minute, second, millisecond, AM/PM
* or blank - could act like a regular expression but would need to have the
    higher unit set. IE: (

		06:50:20.035   , 06:50:20.*   , 06:50:*.*   , 06:*:*.*   , *:*:*.*
			or
		 6:50:20.035 AM,  6:50:20.* AM,  6:50:*.* AM,  6:*:*.* AM, *:*:*.* *

		Not this:
			*:50:*.* *
	).

HH     ,        MM    , ss    , fff
00-23;*,        0-59;*, 0-59;*, 000 - 999;*

	or

H      , tt     , MM    , ss    , fff
0-12;* , AM/PM;*, 0-59;*, 0-59;*, 000 - 999;*

The yyyy,MM,dd could also be done this way so you could get all the rows
for a yyyy****, yyyyMM**, yyyyMMdd

</pre>
1 comment
ADMIN
Angel Petrov
Posted on: 17 Sep 2021 11:25

Hi,

There are various solutions to this problem.

1. Creating a proxy field and filter using it.

2. Implement range filtering.

3. Adding custom logic to modify the time part so that it can fit the filter criteria

4. Implement custom filtering.

Altering the default behavior however is not an option as this would result in a breaking change.

Regards,
Angel Petrov
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.