grid.sort does not remove previous sort icons

[Michiel]

I try to set the sorting of a grid dynamically in javascript. Although this works with the grid.sort function, it does not update the UI correctly.

Go for example to http://demos.telerik.com/aspnet-mvc/grid/sorting?theme=vista

and run 

$("#Grid").data("tGrid").sort("ShipCountry-asc")

You will see that it does a correct sorting by sending ShipCountry-asc, but still shows the column OrderId as one of the sort columns (icon is still present). Do see that OrderId is not in the sort parameter.

Bug? Is there a workaround or another way to do this?

I dont want to do multicolumn sorting; I just want to set a new sort column and clear the old one. Even using sort("") will still show the old sort state.

[Vladimir Iliev]

Hi Michiel,

 
Basically updating the UI of the grid after programmatically updating the sorting currently is not supported and you should remove the sorting icons before applying such sort. Please check the example below:

$("#Grid thead a span.t-icon").remove();
$("#Grid").data("tGrid").sort("ShipCountry-asc");

Kind Regards,
Vladimir Iliev
the Telerik team

[Michiel]

Thanks for the reply. I did found that similar trick and just removed the sort icons using jquery. 

You say it is not supported; so it is a bug? You can set the sort order and the grid does pick the new sort order perfectly and highlights the columns, but it just did not clean up the old state. Should the call to the .sort() not first remove the existing sort UI before applying the new UI?

[Michiel]

Unfortunately it does not work. 

Same url as above

http://demos.telerik.com/aspnet-mvc/grid/sorting?theme=vista

and executing your code:

$("#Grid thead a span.t-icon").remove();
$("#Grid").data("tGrid").sort("ShipCountry-asc");

Yes, it will remove the icons, but will do an ajax call and adds the icon again to the OrderId column. Which is not in the sort options anymore. Even refreshing it will not help. I tried removing it from the columns object but that also does not help.

Any clue?

[Vladimir Iliev]

Hi Michiel,

 

Apologise that I mislead you -  you should clear the previous sorting from the column object also - please check the example below for single-column sorting:

$("#Grid thead a span.t-icon").remove();
grid = $("#Grid").data("tGrid");

for (var column in grid.columns) {

  //remove the sorting on each column
  grid.columns[column].order = "";
}

grid.sort("ShipCountry-asc");

Also as I mention in my previous reply the Sort method does not support clearing the previous sort and If such is needed I would suggest upgrading to KendoUI Grid.


Kind Regards,
Vladimir Iliev
the Telerik team

[Michiel]

Yes, this does work now. Thanks.

I'm a bit confused by your answer however; you provide a fix/work around and at the same time say we need to upgrade because it is not supported.
Upgrading is certainly something we want to do, we love KendoUI! However we used Telerik MVC controls a lot so it is rather time consuming and risky to upgrade. I can't see any place where I can fill support requests against the MVC controls anymore, but it would be nice if this can get fixed in a next release for the MVC controls. I know you cant support them forever, but we need some time to switch to Kendo UI :-)