Unplanned
Last Updated: 31 Aug 2020 19:36 by ADMIN
Peter
Created on: 17 Feb 2020 15:56
Category: Grid
Type: Feature Request
20
Filter date + time in grid

How do I get the filter menu to allow input of Date *and* Time for a DateTime column?

 

5 comments
ADMIN
Marin Bratanov
Posted on: 31 Aug 2020 19:36

Thank you for this feedback, Scott.

Just to clarify, both are possible at the moment through a filter template. You can find an example of min-max for dates here and for numbers here. The fact that the data and filter descriptors are entirely in your control means you can also choose to add, alter or ignore the time portion.

The built-in filtering also lets you use operators like "is before" and "is after" where time portions are far less important.

Lastly, you can implement the data source operations (such as filtering) yourself through the OnRead event which gives you another place where you can alter the filter descriptors.

 

Regards,
Marin Bratanov
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/.

Scott
Posted on: 31 Aug 2020 19:31

I'm going to weigh in here a little more on what I think a data + time filter needs.

1 - The ability to ignore time so you only match on the date.

2 - The ability to do a range on date with time, so you can pick specific hours, etc.

It seems unlikely that someone would want to filter on an exact date and time.

ADMIN
Marin Bratanov
Posted on: 25 May 2020 06:15

Hello Pavel,

The closest feature that will let you do that is a filter template that you can Follow here: https://feedback.telerik.com/blazor/1407773-custom-filter-components-filter-template. You can also click the Follow button on this page to get email notifications for status changes on this one too.

 

Regards,
Marin Bratanov
Progress Telerik

Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
Our thoughts here at Progress are with those affected by the outbreak.
Pavel
Posted on: 24 May 2020 15:58
Is there any news about this feauter ?
ADMIN
Marin Bratanov
Posted on: 17 Feb 2020 16:27

Hi Peter,

I moved this to our Feedback portal so you can Follow it at this URL: https://feedback.telerik.com/blazor/1454076-filter-date-time-in-grid. At the moment, the filter is a DatePicker, ideally it should be either a DateTimePicker, or it should be configurable what to use (Date, DateTime or Time picker).

For the time being, the only option I can offer is building an external filter like here: https://feedback.telerik.com/blazor/1440872-search-panel

Regards,
Marin Bratanov
Progress Telerik

 UI for Blazor