Results 1 to 4 of 4

Thread: how to save pivot grid settings to database?

  1. #1
    Sencha User
    Join Date
    Oct 2015
    Posts
    52
    Answers
    1

    Default Answered: how to save pivot grid settings to database?

    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

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

    Code:
    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:

    Code:
    pivot.getMatrix().reconfigure(settings);

  3. #2
    Sencha User
    Join Date
    Oct 2015
    Posts
    52
    Answers
    1

    Default someone here to help?

    Quote Originally Posted by xnathan View Post
    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?

  4. #3
    Sencha User
    Join Date
    Oct 2009
    Posts
    30
    Answers
    1

    Default

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

    Code:
    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:

    Code:
    pivot.getMatrix().reconfigure(settings);

  5. #4
    Sencha User
    Join Date
    Oct 2015
    Posts
    52
    Answers
    1

    Default

    This is what I want, thanks

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •