datasource grid date formatting

[Max]

https://dojo.telerik.com/aDalAvav/3

 

Dear sirs, the architecture requires to call "doc.subdoc" field by it's name.

 

So I have troubles formatting the dates to my localdate, as you can see the example.

 

Please, help. 

Thank you.

[Stoyan]

Hello, Max,
thank you for sharing your code.

The second column in the grid is not getting formatted correctly since the "bd" column field is a complex type and should be of type "object":

schema: {
      	model:{
          id:"email",
          fields:{
            dt:{type:"date"},
            bd:{type:"object"}
          }
        }
      }

You can read more about the supported dataSource types in an editable Kendo UI Grid here.

That said, to format the column as a date you can use a Kendo UI Template. This will ensure the required rendering, but as the "bd" field it is of type "object" you will need to specify the editor for the column:

{ field: "bd.dt", template:"#=kendo.toString(kendo.parseDate(bd.dt),'d')#", editor:datePickerEditor}

This way on editing the "bd.dt" field will be parsed as a date correctly. This article goes over the requirements for defining a custom grid editor and you can see a runnable demo here. For your scenario you can define a DatePicker editor via the datePickerEditor function:

function datePickerEditor(container, options) {
            $('<input name="' + options.field + '"/>')
                .appendTo(container)
                .kendoDatePicker();
        }

I applied the above-suggested approach to your example and you can review it here: https://dojo.telerik.com/@Stoyan/IpEJOtoF

Please don't hesitate to reach out if more questions arise.

Regards,
Stoyan
Progress Telerik

[Max]

Sir, thank you for complete and exhaustive answer.