It is possible to add and remove columns to the server side row model without having the row model reset.
Changing columns allow you to specify new column definitions to the grid and the grid will work out which columns are new and which are old, keeping the state of the old columns.
For the server side row model this means adding and removing columns will reload the data if the changed column has row group, pivot, value, sort or filter active. This is because a change to row group, pivot, value, sort or filter will impact the row data that comes back.
The example below demonstrates how changing columns impacts the server side row model. The following can be noted:
- Adding or removing Athlete, Age or Sport will not reload the data as they have no row group, pivot, value, sort or filter set.
- Adding or removing Country or Year will reload the data as they are part of the grouping.
- Adding or removing Gold, Silver or Bronze will reload the data as they are selected as values.
- If you apply a sort or filter (Country and Years columns are filterable) to a column and then remove the column then the data will reload.
Continue to the next section to learn about CRUD Operations using the Server-side Row Model.