How to make foreign key column switchabel?

[Thomas]

Dear fellow warriors,

I'm experimenting with the foreign key example with the aim to make the foreign key column, so that the user can toggle between the foreign key values and the foreign key texts. I couldn't find API-calls for such a thing so I tried this:

var foreignKeyGrid = $("#grid").data("kendoGrid");
delete foreignKeyGrid.columns[1].values;  //deletes the foreign key mappings from the "Category"-Column
foreignKeyGrid.refresh();

This doesn't have any effect, the grid still shows the category names instead of the category ids. Any ideas how I could achieve the desired behaviour? (next step would be to toggle back, i.e. show the category names again. Next step would be to connect all of this with a UI-Toggle-Switch)

BTW the refresh call isn't my preferred one for this problem, as it re-requests the data from the DataSource - this causes extra network traffic for remote data grids, is there an API-call for a simple client-side redraw?

Many thanks for your advice,
Thomas

[Petur Subev]

Hello Thomas,

The Grid does not support changing the Column template on the fly. You could try to achieve your goal with a Template column.

On a side note calling the Grid refresh should not perform an Ajax request - the Grid should be redrawn using the local data.

All the best,
Petur Subev
the Telerik team