Author Topic: Save the Grid Maintanance per User  (Read 4015 times)

Sunny

  • Pro Enterprise
  • Jr. Member
  • *
  • Posts: 59
    • View Profile
Save the Grid Maintanance per User
« on: July 24, 2015, 12:55:49 am »
Hi admin,

We have a requirement, that users should able to hide/unhide columns, change column order, freeze/unfreeze column position and save the preferences the user has choosen. Can we able to save the grid state per user remotely in database, so that when user views grid next time the saved preference on grid have to be shown.

Thanks.

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6265
    • View Profile
Re: Save the Grid Maintanance per User
« Reply #1 on: July 24, 2015, 10:48:58 am »
There is API for state maintenance in version 3, loadState & saveState. The string returned from call to saveState can be saved in database and same string could be passed to loadState after grid initialization to restore previous state.
 
http://paramquery.com/pro/api#method-saveState

http://paramquery.com/pro/api#method-loadState

http://paramquery.com/pro/demos/grid_state

Sunny

  • Pro Enterprise
  • Jr. Member
  • *
  • Posts: 59
    • View Profile
Re: Save the Grid Maintanance per User
« Reply #2 on: August 21, 2015, 12:12:36 am »
Hi,

In my grid, user has option to freeze/unfreeze columns. So, while testing noticed Freeze/Unfreeze column position is not been saved via 'saveState' .

Can you please advice?

Thanks.

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6265
    • View Profile
Re: Save the Grid Maintanance per User
« Reply #3 on: August 21, 2015, 12:25:13 pm »
Currently this is the list of options saved in saveState, frozen rows/columns is not among them.

height, width, colModel, sortModel, pageModel, groupModel.

It has been included in the next version, thanks for your feedback.
« Last Edit: August 21, 2015, 12:40:58 pm by paramquery »

Sunny

  • Pro Enterprise
  • Jr. Member
  • *
  • Posts: 59
    • View Profile
Re: Save the Grid Maintanance per User
« Reply #4 on: August 21, 2015, 07:08:51 pm »
Thank you. Appreciate if you can let me know when next version will be available, so that I can let my users know.

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6265
    • View Profile
Re: Save the Grid Maintanance per User
« Reply #5 on: August 22, 2015, 07:54:48 am »
ETA for next version has been postponed to first week of Sept 2015 as we are adding cut paste, delete and many other Excel like useful features.