Blogs

Thinking Out Loud

WinForms DataGrid Date Filtering

     

Last week Julian blogged about the new DevExpress date filtering feature to be made available with the next release of the XtraGrid Suite (v2009 vol 1). I wanted to post a few images of how this new feature has evolved after internal and external feedback.

WinForms DataGrid Date Filtering

Notice the tooltip as you hover over a checkbox - this was implemented in the last couple of days to help end-users view the criteria prior to filter execution.

WinForms DataGrid Date Filtering

WinForms DataGrid Date Filtering

 

WinForms DataGrid Date Filtering

Based on feedback, Mike updated this new feature- unlike the first variant, the shipping version will allow you to specify filter criteria based on specific business needs (notice the checkboxes below the calendar)

 

Published Jan 29 2009, 03:38 PM by Ray Navasarkian (DevExpress)
Filed under: ,
Technorati tags: v2009.1, XtraGrid
Bookmark and Share

Comments

 

Linton said:

Nice work.

Suggestion: The calendar "selection" should update when the check box is clicked. For example, if we have a "Month To Date" filter, when the user checks that filter, the days included in the Month to Date filter range would be highlighted (selected).

January 29, 2009 6:47 PM
 

drew.. said:

will we and the end-users be not needing to create the >= and < required to find a date within sql server like we do now? This is one of my long-standing peeves with sql and date processing.

As well, are these checkboxes mutually inclusive as checkboxes normally are? This almost seems wrong and seems more radio-button-oriented. Just a thought, cheers! drew..

January 29, 2009 8:52 PM
 

Phillip Roux said:

This looks great, can VCL Customers expect something similiar?

January 29, 2009 9:09 PM
 

Steve Sharkey said:

Excellent.

It is a shame that the date picker in WinForms isn't as nice as the aspx one though - particularly when selecting a date that is some time in the past where the WinForm version you have to repeatedly scroll through the years the ASP version allows you to click on the date and move straight to the right month and move a decade at a time. Any plans to upgrade the WinForms date editor?

January 30, 2009 3:16 AM
 

Ralf Warnat said:

I'll love that !

If I specify filter criteria based on specific business needs,

will I have an event (for disabling other options) ?

That would be great.

Holding my breath ...

January 30, 2009 3:40 AM
 

Ahmed said:

when last month is selected, last week and yesterday records will also be included. why don't provide a visual feedback for this situation? a little dot sign would be enough for visual feedback (instead of auto-selecting last week and yesterday check boxes)

BTW this filter pop-up is really cool!

January 30, 2009 7:00 AM
 

Per said:

It looks nice! Will it also be possible to easily choose a range of dates ? Between two dates.

January 30, 2009 7:44 AM
 

Sigurd Decroos said:

Really interesting. What about a custom range of dates? So the user would be able to enter a start and end date...

January 30, 2009 8:16 AM
 

Alexander Koger said:

Hi,

very nice. As far as I know filter settings could be persisted.

Will there be generic placeholders for those relative filter like "Early this week" or will the filter result in an empty list the week after?

Regards,

Alex

January 30, 2009 8:43 AM
 

Tony Zerep said:

Select Categories from Combo Box mode  or from Check Box mode. In Check Box mode if the list have a lot of options, the popup windows is very large.

January 30, 2009 8:56 AM
 

Crono said:

I hope you guys thought about making this a standalone control as well?

January 30, 2009 10:45 AM
 

Robert Fuchs said:

Sweet.

I especially like the fact, that we can specify filter criteria based on specific business needs.

I see: DX is learning from us - RW developers ;-)

January 30, 2009 1:09 PM
 

nomad said:

"...unlike the first variant..." Does this mean the ShowFilterPopupListBox event is being broken? The grid already has this option via ColumnFilterInfo.

February 3, 2009 9:14 AM
 

Guido Volkmann said:

Looks Good! Only missing a "null/empty"-statement.

February 6, 2009 7:38 AM
 

caubebutchi(DX_vietnam) caubebutchi said:

oh ....it's very good . I can't waiting for DX 2009. vol1 . I love it

February 9, 2009 3:01 AM
More from DevExpress
Live Chat
Have a pre-sales question?
Need assistance with your evaluation?
We are here to help.
Chat is one of the many ways you can contact members of the DevExpress Team. We are available Monday-Friday between 8:30am and 5:00pm Pacific Time.
If you need additional product information, require pre-sales assistance, or want help with your order, write to us at info@devexpress.com or call us at
+1 (818) 844-3383.