Updating Grouping/Aggregates After the Group Field Has Been Edited

[Kyle T.]

I have a grid that is grouped by an account id.  In this case it is valid for the end user to be able to change the account id that each row is associated with.  Right now, when the end user updates the account id via inline editing the data is updated but it is still in the previous grouping.

My question is how to do I force the row to move to the correct group, as well as update the group totals, after the account id has been changed?

Thanks,
Kyle Tillman

[Kyle T.]

Forgot to mention that this is using batch editing.

Thanks,
Kyle

[Alexander Valchev]

Hi Kyle,

I am afraid that your scenario is a bit unclear - in the first post you are saying "end user updates the account id via inline editing" and in the second "this is using batch editing".

When an inline editing mode is used, the item should be updated after the user hits the save button and the item should be placed in the corresponding group immediately. If a batch editing is used, the grid will re-group after the user presses "Save changes" button.

If you want changes to be saved automatically in batch (incell) editing mode please set the autoSync option of the dataSource to true. For convenience I prepared a small example that demonstrates the approach.

I hope this will help.

Kind regards,
Alexander Valchev
the Telerik team

[Kyle T.]

Alexander

I apologize for the confusion on the terms.  We are using batch editing based on this demo: http://demos.kendoui.com/web/grid/editing.html.  From there we have added grouping as well as aggregates at both the group level and the grid level.

The requirement is that the end user be able to make these changes without saving them back to the database. They want to be able to make changes to multiple rows of data and see them all as one unit before saving them.  In some cases that will include changing the Account Id that the rows are grouped by.

Does that make sense?  Would you like me to create an example on JSFiddle.net?

Thanks,
Kyle

[Kyle T.]

Alexander

I have an update.  After meeting with the end users I was able to get them to agree to letting me change the requirements so this is no longer an issue.  

However, I am still curious if the UI can be re-grouped/re-aggregated on unsaved data.

Thanks,
Kyle

[Alexander Valchev]

Hello Kyle,

I am afraid that this is not possible. The changes takes effect after the data is saved.

Regards,
Alexander Valchev
the Telerik team