Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

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

Answered
Cedric Gaines asked on January 13, 2020

understood,
Question:
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?
Thanks,

1 answer

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster January 13, 2020

Hello,
 
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,
Illia

Please login or Register to Submit Answer