You can target updates to a single row or cell. Updating a single row means asking the grid to replace the data item for one specific row. Updating a cell means keeping the data item but asking the grid to replace one attribute of that data item.
Both single row and single cell updates are done by first getting a reference to the row's Row Node and then using the relevant Row Node API method. See Accessing Data on how to access Row Nodes. Once you have access to the required Row Node, you update its data with the following Row Node API methods:
Replaces the data on the
Replaces the value on the
colKey The column where the value should be updated.
newValue The new value.
eventSource The source of the event, optional.
rowNode.setDataValue the grid's view will automatically refresh to reflect the change. There is no need to manually request a refresh.
rowNode.setDataValue the grid will not update to reflect a change in sorting, filtering or grouping.
To have the grid update its sort, filter or grouping call the Grid API
If you want the grid to automatically update sorting, filter or grouping then you should consider using Transaction Updates.
The example below demonstrates the following:
- Set Price on Toyota: The price value is updated on the Toyota row and the grid refreshes the cell.
- Set Data on Ford: The entire data is set on the Ford row and the grid refreshes the entire row.
- Sort: Re-runs the sort in the Client-Side Row Model - to see this in action, sort the data first, then edit the data so the sort is broken, then hit this button to fix the sort.
- Filter: Re-runs the filter in the Client-Side Row Model - to see this in action, filter the data first, then edit the data so the filter is broken (i.e. a row is present that should not be present), then hit this button to fix the filter.