Grid reorder rows issues if sort is enabled

[Asad]

Hi there

I have a grid with draggable functionality but if I enable the default sort the drag & drop won't work any more.

 

I'm setting the default sort in jquery:

grid.dataSource.sort({ field: "Id", dir: "asc" });

 

I've tried to do it in C# code but got the same results.

 

Can anyone help me with it ?

 

Thanks

[Asad]

I was able to solve the issue by ordering the records on database level, which I was trying to avoid. But, it's better than nothing at all.

[Stoyan]

Hello Asad,

I am glad you have found a away to resolve the encountered issue, because this use case is a known limitation of the Grid's Drag and Drop functionality:

dataSource operations (for example, sorting, filtering, grouping, and so on) that involve rendering rows in a different order than their natural one are not supported.

Please don't hesitate to contact us, if more questions occur.

Regards,
Stoyan
Progress Telerik