Add/reorder columns on Datagrid2 without breaking preferences of all users?
0
I recently implemented an overview with lots of data and thus columns in a single datagrid. I also added the possibility to have multiple variations of the same datagrid, for whatever means a user can have (e.g. view A with columns ABC and View B with columns A D F G). This has received a lot of positive response. However I recently discovered that when I add a column or reorder columns it breaks the datagrid preferences of all users. We save them in a per-user owned entity/attribute. I find it crucial that the column and filter preferences of all users are preserved, even when updating the datagrid.Has anyone found a solution for this or can think of one?The only thing I can think of is frequently backing up the datagrid-preferences string and after deployment restoring those backups while appending edits. E.g. If we had columns 1-20 and add a 21st column, we append the existence and order of the 21st column to all of eachothers restored preferences-strings. This can of course very easily be forgotten to do, so it would be great if there was a more failsafe method.