how to save pivot grid settings to database?

[xnathan]

want to know the way to save "all fields settings" on privot grid to DB, already save the configuration of pivot grid to DB,but not "all fields settings"

where i can get those "settings" config?
Xnip2019-10-01_16-48-43.jpg



thanks

[xnathan]

want to know the way to save "all fields settings" on privot grid to DB, already save the configuration of pivot grid to DB,but not "all fields settings"

where i can get those "settings" config?
Xnip2019-10-01_16-48-43.jpg



thanks

someone here to help?

[ivanleblanc]

Looking at the code used when that gear icon is pressed. Sencha does this to get the settings:

settings = pivot.getMatrix().serialize();
delete(settings.leftAxis);
delete(settings.topAxis);
delete(settings.aggregate);

This will return an object that you can then send to your server to save to the database.

Then you can retrieve the settings object from your database and apply it back to the pivot grid with:

pivot.getMatrix().reconfigure(settings);

[xnathan]

This is what I want, thanks