How to make a custom filter on month ?

[Elie]

Hello,

I have a GridDateTimeColumn I want to make a custom Filter, which I can filter on the month's date.

On the filter, we see "January, February..."

How to make this, please ?

I made this, but I failed to filter the items.

 void sfDataGrid_FilterItemsPopulated(object sender, GridFilterItemsPopulatedEventArgs e)

        {

            if (e.Column.MappingName == "ShippedDate")

            {

                var itemsSource = e.ItemsSource as List<FilterElement>;

                itemsSource.Clear();

              

                itemsSource.Add(new FilterElement { ActualValue = new DateTime(2000, 1, 1), DisplayText = "January", IsSelected = true });

                itemsSource.Add(new FilterElement { ActualValue = new DateTime(2000, 2, 1), DisplayText = "February", IsSelected = true });

                itemsSource.Add(new FilterElement { ActualValue = new DateTime(2000, 3, 1), DisplayText = "March", IsSelected = true });

            }

        }

Regards

[Sivakumar R]

Hi Elie, 

 

We have prepared the sample to filter based on month and year. Please find the sample from below location, 

http://www.syncfusion.com/downloads/support/directtrac/166380/ze/WRT2096081792 

 

Thanks, 

Sivakumar 

[Djooleean]

Hi guys,

when I run the sample, it doesn't work.

FilterControl's items are well formatted (ie: "March 2009") but when I filter, no more value is displayed on the grid...

So filter items are good but the filtering method doesn't work anymore (see images).

Any idea ?

thanks, Julien

[Jai Ganesh S]

Hi Elie,  

 

The attached sample working fine and also the filtering also working as expected in our side, 

 

 

 

 

 

 

Could you please check this in your side and please share in which essential studio you have used in your application? This would be more helpful for us to analyze further. 

 

Regards, 

Jai Ganesh S