Passing original values when updating row in grid?

[Michael]

How can I get the original values of the row when calling an update function?

My main issue is that we have a few tables where the primary key is a value we allow to be changed. However, the default auto-generated update functions will fail on update if that value is changed in the grid editor because it won't be able to lookup the row you're updating since it only knows what you want to change the value to and tries to look the row up by the new value.

How can we handle this situation?

[Stefan]

Hello, Michael,

The original value(before edit) can be retrieved on the beforeEdit event of the Grid and saved in a variable to be used later if the Primary Key was edited:

https://docs.telerik.com/kendo-ui/api/javascript/ui/grid#events-beforeEdit

The variable can be passed to the server using the update.data property of the dataSource:

https://docs.telerik.com/kendo-ui/api/javascript/data/datasource#configuration-transport.update.data

I hope this is helpful.

Regards,
Stefan
Progress Telerik

[Brian]

Hi Stefan, I am trying to implement this functionality in a grid today, the doc you refer to doesn't mention anything about how to obtain the original value. I assume it has changed since this post was written, but how do we go about getting the value now?

[Konstantin Dikov]

Hello Brian,

The "beforeEdit" event exposes the model in the arguments, which holds the values before the changes that will be applied during the editing:

beforeEdit: function(e) {
    var dataItem = e.model;
  }

Hope this helps.


Regards,
Konstantin Dikov
Progress Telerik