[Solved] Grouping changes the datasource - KendoUI Grid

[divyang]

Hi,

I am evaluating KendoUI at the moment to check how it works with Microsoft LightSwitch. I wasn't aware that as a trial holder I can get the benefits of premium support. I've asked this same question in general forum & waited for couple of hours but didn't get any reply so asking it here now.

I am using Kendo grid in a LightSwitch project, the data is coming from a web API in json format. I have some drop-downs which changes the data source of the grid. The grid loads fine, changing the drop down also changes the data-source which is fine too. But there are couple of Issues:
1) If I perform grouping, it reverts back the data source of the grid to the initial state.
2) Changing the drop down changes the data source but removes the formatting applied to columns.

Thanks.

[Alexander Popov]

Hi divyang,

I am not sure what exactly is causing this behavior, so I would ask you to share as much related code as possible, or ideally - a runnable sample project.
On a side note - all forum posts are guaranteed to be answered by a Kendo UI representative in 48 hours, regardless of where the post was submitted.

Regards,
Alexander Popov
Telerik

 

 

[divyang]

Apart from the extension is there any other restrictions to upload a file? I've tried couple of times & it failed with the attached error, I assume it could be down to the size of the file which is 20.1MB. 

I've sent my one drive link to, [e-mail].

[Alexander Popov]

Hi divyang,

I reviewed the provided project and noticed that the Grid's DataSource is fed new items through the data method. Keep in mind that the data method expected the data to be parsed, so the DataSource will not apply any of the parse operations to match the data types specified in the schema.model. You can use a slightly different approach to get similar results. Instead of simply specifying the URL and the dataType of the read operations - use a custom JavaScript function to make the Ajax request (based on certain criteria). Then, you can call the DataSource's read method when the DropDownList's value changed and modify the URL accordingly before making the Ajax request.

Regards,
Alexander Popov
Telerik

 

 

[divyang]

That works like a charm, thanks for the support.
I understood why the grid was not retaining the schema, but I have a question - in the example I've sent, when the grouping is performed on an empty grid why the grid is loading default data?

[Alexander Popov]

Hello again divyang,

Basically, changing the items through the data method does not update the DataSource's pristineData array (used internally). In case you wish to manually change the data, I would suggest using the Grid's setDataSource method instead.

Regards,
Alexander Popov
Telerik