DateTime Column Filter

[sri]

In Kendo UI Grid, if you have a dateTime Column then the column filter input has a date picker but no time picker. Due to this if you select option IsEqualTo and give a date then you get zero results as the time is set to 00:00:00 in the filter but the columns have some time value.

eg.

values in my column are
08-10-2012 15:08:00
05-09-2012 15:23:00

and when u use the filter then the value in the filter is
08-10-2012 00:00:00

hence when You give the option of IsEqualTo then you get zero values.

[Steven]

Did anyone find a solution for this? I store all my date/times as datetime fields. I need the filter with datepicker to work for matching a date to a datetime field. This must be possible.

[Rosen]

Hello Steven,

Although, this is not possible with the current release, we are working on such improvement which should be included in the next service pack.

All the best,
Rosen
the Telerik team

[Palani]

Yes it is possible.
@(
 Html.Kendo().Grid<Employee>()
 .Name("gd")
 .Filterable(f => f.Extra(false))
.Columns(x =>
    {
        x.Bound(p => p.ID);
        x.Bound(p => p.Name);
        x.Bound(p => p.Email);
        x.Bound(p => p.DateOfJoining).Format("{0:MM/dd/yyyy hh:mm tt}").Filterable(f => f.UI("DateTimeFilter"));
    })
    .DataSource(d => d.Ajax().Read(a => a.Action("ReadData","Home")))
)


<script type="text/javascript">
    function DateTimeFilter(control) {
        $(control).kendoDateTimePicker();
    }
</script>

[SEAN]

Rosen, did this ever get implemented, in the 2014.1.328 release I'm still seeing column filtering on datetime columns return no results when you set the filter to Is Equal To.

[Rosen]

Hello SEAN,

The mentioned improvement is the feature Palani is referring to. You may modify the filter UI element to be a DateTimePicker widget instead of a DatePicker. This way the user will be able to pick the exact date and time. However, if you need to keep the DatePicker, it will be required to strip the time portion of the dates in order filtering to work.

Regards,
Rosen
Telerik

 

 

[Andreas]

This does not even work in the latest release => 2015.1.408.545

@Rosen How can the time portion be stripped of a datetime value without converting the datetime to a string? When It is a string then the filtering with "is greater/smaller than" is surely be broken too. 

 This is the job of the telerik dev to strip the time from the source datetime values when the filtering is done.

 I am dissappointed from telerik how such a common feature does not work for years...

[Rosen]

Hello Andreas,

You do not need to convert the DateTime to String, but instead you should create a new DateTime object which contains only the Date portion of the original date.
Also another approach to handle this is described in this forum post - which uses a custom model binder to change the filter descriptors.

Although, it may seems a bit odd the way date filtering is handled, this is due to the fact that there is not way to automatically know if it should match the exact date and time or strip the time portion. Thus, it keeps the time as this is the less destructive of the both and give the developer the option to decide the behavior by providing the correct data.

Regards,
Rosen
Telerik

 

 

[SEAN]

Rosen, that doesn't make any sense. You say there is no way to know if it should match the exact date and time or strip the time portion, but that is not true, if the UI element is a DatePicker then we clearly only want to match the date portion, it makes no sense at all to include the time when the user cannot have possibly entered the time. If the developer wants to filter to specific times (a fringe use case) then make them do the extra work, the way it works now you're making developers do extra work to implement the most common use case.

[Rosen]

Hello Sean,

Actually, the filtering is done either by the DataSource or on the server-side. Thus, the DataSource(or server method) does not have any knowledge what UI (if such is used at all) is used to create the filter expressions passed to its filter method. As I have mentioned, it is currently not possible to automatically pass this information from the UI to the DataSource, thus it is in the hands of the developer to implement the correct behavior.

Regards,
Rosen
Telerik