Details about my grid:
Kendo version 2014.2.716
Grid has the following features:Configured by Razor GridBuilder, loaded via ajax, no page size (grid scrolls internally), grouped, each row has an expandable detail row, and 6 monetary columns are aggregated, with aggregates shown in both the group footer and grid footer.
Problem: We want aggregates to update whenever you change a value in the grid.
Solution #1: Consensus seems to be to call e.sender.dataSource.fetch(); That worked, but had the following consequences:
(1) Clears dirty indicators in cells, (2) Clears any open detail rows, (3) Opens any collapsed groups.
We can solve all three of those problems manually, but it's getting to the point where I wonder if just manually updating the aggregates, for finding another way other than re-fetching would be a better solution than hacking the grid back to its pre-fetch state. What made it extra difficult is the rows and cells are all re-created, so it's not as easy as just tracking a list of dirty cells, and marking them dirty again; you'd have to track the rowid/cellindex pair, and find the equivalent new cells.
Does anyone have any suggestions?
3 Answers, 1 is accepted
Assuming that you are using client-side operations, the aggregates will automatically be recalculated by the dataSource on change so it should be simpler to just update the displayed aggregates than to rebind the grid and then to restore its previous state. I created an example that demonstrates redrawing just the group footers and the grid footer.
Regards,
Daniel
Telerik
Rank 1
Looks promising, thanks! I'll try it out today.
Rank 1
This worked perfectly, thanks! So much better than calling fetch, and manually reconstructing the cell states (obviously).
I actually improved a bit on your code by only updating the group footer for the row which changed, rather than updating all group footers. Process went like this:
1. Get the group for the current row from dataSource.view().
2. Get the item's row in the grid by uid.
3. itemRow.nextAll("tr.k-group-footer:first").replaceWith(grid.groupFooterTemplate(itemGroup.aggregates));