Grid Datasource is DateTime, but handled as a String

[Steven]

 

This is (in short) my Grid code:

@(Html.Kendo().Grid<Model>()
.Name("Grid")
.Columns(columns =>
{
 
    columns.Bound(p => p.From).Format("{0:dd.MM.yyyy}").Width(150).Filterable(f => {
        f.UI("DateTimeFilter");
        f.Cell(cell => cell.ShowOperators(false));
    });
})

.Filterable(filterable => filterable
.Extra(false)
      .Operators(operators => operators
          .ForString(str => str.Clear()
              .Contains("Contains")
          ).ForDate( date => date.Clear()
         .IsGreaterThan("After")
         .IsLessThan("Before")
          )
          .ForNumber(number => number.Clear()
        .IsGreaterThan("Higher than")
        .IsLessThan("Lower than")
          ))

      )
    .Sortable()
    .Scrollable()
    .DataSource(dataSource => dataSource

        .Ajax()
        .ServerOperation(false)
        .Read(read => //get some data)
        
     )
        )

 

The fact is that p.From is treated as a String (so he gets the filter of a string = .ForString(...)). 

How is this possible? the format is also not aplied, but that works when i do this: .ClientTemplate("#= From? kendo.toString(kendo.parseDate(From), 'dd/MM/yyyy') : '' #")

 

Anybody expirienced this problmen yet?

[Steven]

Fixed it by creating a custom datasource and specify the model again (no idea why):

...

 .Schema(s => s
         .Data("Data")
           .Total("Total")
           .Errors("Errors")
           .Parse(@<text>function (data) {
        
        return data;
        }</text>)
            .Model(model =>
            {
                model.Field(m => m.From);
            })
    )
    .Transport(t =>
    {

...

 

Only the Filtering does not work now :-)

[Stefan]

Hello, Steven,

Thank you for the provided code and providing the additional details after modifying it.

In general, this issue should only occur if the type fo the field is not set as DateTime in the Model.

Another issue could be that the custom UI "DateTimeFilter" used for filtering has a different format.

Could you please share the Model and one record of the Data which is passed to the Grid, so I can test if there are any issues when parsing the values.

Regards,
Stefan
Progress Telerik

[Steven]

I did not need to create a custom datasource, only attach the model.

The model looked like this: 

      [Display(Name = "From")]
        public DateTime From { get; set; }

[Stefan]

Hello, Steven,

Based on the provided information it seems that the issue is resolved after attaching the model.

If my assumption is not correct, please provide the filter UI and the data, so we can investigate.

Regards,
Stefan
Progress Telerik