Saving Grid State

Any luck? I would also like to see some information on this topic.

Hi,

 A possible solution is to get the current state of the datasource and persist it in a cookie or post it to the server. Here is an example showing how to get the grid state:

Regards,
Atanas Korchev
the Telerik team

I'm getting a 404 on the JS FIddle on this page... can you repost?

-John-

Any follow up on this jsfiddle?  I am still wondering how to maintain column order.

-john-

Hello,

 The idea is to use the grid's dataSource API to get the state. The pageSize(), page(), sort(), filter(), group() methods can be used for this purpose. Here is an example: http://jsbin.com/erefug/1/edit

Regards,
Atanas Korchev
the Telerik team

Just following up, Thanks!  That is a perfect example.

-john-

Hello, thank you for this information.  

Is there other documentation on saving the Grid State;  i.e. saving information about the columns themselves?  I think the first question should be, can Column State information on the grid be retrieved similar to the methods listed in Atanas Korchev's very informative posting;  pageSize(), page(), sort(), filter(), group()?   I do not see similar functions for retrieving Column information.   

I'm most interested in retrieving the Columns that the user has set (via the columnMenu) to show on the Grid and also the Order that the user has arranged the columns in and the column width.   I want to be able to save this grid state Column information when the user exits the grid and then be able to re-load that same state when the user opens the grid again.  

Any help on this is much appreciated.   

Even knowing if any of these things is possible would be of great help.

(1) retrieving the "columns" that the user has "shown" on the grid (one's they checked on the columnMenu) 
(2) retrieving the "order" of the columns that the user has set
(3) retrieving the "width" of the columns that the user has set

Thank you very much,  --Steve

Hi Steve,

 You can use the columns field of the grid to get the column state. Here is a live demo showing the same: http://jsbin.com/ilahuh/1/edit

Kind regards,
Atanas Korchev
the Telerik team

@Steve,

Regarding Column Order:
The order is based on the way the columns are inserted into the datasource.  The way I have seen it done is that you check an index of the column and loop through them and splice/push into the column array.

Regarding the size: you can use the columns that Atanas suggested and apply the query for that object
yourgrid.data('kendoGrid').dataSource.query(yourColumnProperties);

Note on the size:  If you have fixed width for ALL of the columns, it will not look right, because nothing is a percentage.  It is recommended that you have at least one column based on a percentage so it can fill your column width.

Hope this helps.

-john-

Thank you very much Atanas and John for those replies, they help quite a lot!  I will be using your information today to get something working.  If you happen to find any similar information regarding this, posting something about it here will be very much appreciated.  Thank you very much for your help!

Best regards,
Steve Hill