I'm working on a large grid (dozens of columns, thousands of rows). The grid is loading the entire dataset on the client (serveroperation = false) and using virtual scrolling.
We are allowing users to save multiple states which are persisted in a database and selected with a dropdown menu. The dropdown initiates an ajax call which gets the options (in json) from the database and applies it to the grid.
I would like to have the settings applied without reloading the data from the client. I have tried creating a handler for onDataBinding but it doesn't work. What is the best way to accomplish this?
Also, is there an easy way to reset all of the settings including re-ordering all the columns back to their original position. I found a function to do this on the web, but it takes 30 seconds for the number of columns we have which is unacceptable.