[CLOSED] dynamic date filter not working

[PriceRightHTML5team]

I have added dynamic filter to grid which is dynamically created as below:

 DateFilter df = new DateFilter();
                df.DataIndex = "MONTH_YEAR";
                df.DatePickerOptions.TodayText = "Now";
                df.Format = "MMM-yy";
                gf.Filters.Add(df);

I am binding the model field to store as :

  model.Fields.Add(new ModelField("MONTH_YEAR"));

the date format it displays as : Aug-13, May-13

But when i use the filter no record shows up. What am i missing.

Also how do i customize the filter to only show Months on the date picker

Thanks in advance

[Daniil]

Hi @PriceRightHTML5team,

I think you should set up Type.Date for the ModelField.

[PriceRightHTML5team]

Hi @PriceRightHTML5team,

I think you should set up Type.Date for the ModelField.

I did that but still its not working . The date format i am showing on the grid is "MMM-yy"
so it show as "Aug-13","Sept-13","Oct-13"... and so on.

How do i customize the filter so that it filters records based on this format

[Daniil]

Please provide a full test case.

[PriceRightHTML5team]

Please provide a full test case.

@( X.Panel().Collapsed(false).ID("pnlPriceTrendTabular")

                .Height(400)
                 .DefaultAnchor("100%")
                .Layout(LayoutType.Fit)
                .AutoScroll(true)
                .Control(item => this.Initchart(item))

         )

Below is the MVC code

@functions{
 private void Initchart(Panel pnlGrafico)
    {
  Ext.Net.GridPanel grid = new GridPanel()
        {
            ID = "gridSnapshotTab",
            Layout = "Container",
            Scroll = ScrollMode.Both,
            ForceFit = false,
            AutoScroll = true,
            ColumnLines = true,
            EmptyText = "No data found"
        };
var result = svc.getData();

 Store store = new Store();
        store.ID = "StoreTabView";
        var model = new Model();

model.Fields.Add(new ModelField("MONTH_YEAR",ModelFieldType.Date));
  model.Fields.Add(new ModelField("CountryName"));

      store.Model.Add(model);
        store.Data = result;
        store.LoadData(result);

   grid.Store.Add(store);

grid.ColumnModel.Add(new DateColumn() {
                            Text = "Month",
                            DataIndex = "MONTH_YEAR",                         
                            Format = "MMM-yy"
                        });
  grid.ColumnModel.Add(new Column()
                {
                    Text = "Country",
                    DataIndex = "CountryName"
                });

   GridFilters gf = new GridFilters();
        gf.Local = true;

 DateFilter df = new DateFilter();
                df.DataIndex = "MONTH_YEAR";
                df.DatePickerOptions.TodayText = "Now";
                df.Format = "MMM-yy";
                //df.Type = FilterType.Date;
                gf.Filters.Add(df);
 gf.Filters.Add(new StringFilter() { DataIndex = "CountryName" });
grid.Features.Add(gf);      
       
        pnlGrafico.Items.Add(grid);
}
}

[Daniil]

Thank you.

It appears to be working as expected for me.

What are the steps to reproduce the issue using the test case?