🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

Is it possible to export the filters applied to a pivot table for later use?

Cedric Gaines asked on January 13, 2020

Is there a way to export / save a pivot grid’s filters and such into a variable / local / session storage so that if the a user goes to another page, and return to a page, if the export filter settings are stored in say session storage, then I can reload the filters and such back into the grid so that the user can pick up where they left off without having to reset the filters and such?

1 answer

Illia Yatsyshyn Illia Yatsyshyn Flexmonster January 13, 2020

Thank you for contacting us.
The current configuration of the pivot can be saved as a .json file containing the report object. Such an object keeps all the possible aspects of pivot tables and pivot charts adjustments.
More information about the report object and its properties can be found following the link: Report Object.
The report object can be obtained using the getReport API call provided by the component. Such a method returns an inline report object. It can be used in order to implement saving the configuration within the session storage. You are welcome to find out detailed information about the getReport method and its parameters by the link: The getReport Method.
Please contact us in case of additional questions.
Best regards,

Please login or Register to Submit Answer