Save filter settings

Getting help Questions
1

When the page is reloaded then selected filters disappear and I must select filters again. Is there any option/functionality which save filter settings?

2

Yes, you can collect and save (then load) filters. This action can be done via afterFilter` callback. It looks like that:

afterFilter: function(formulaStack){ }

It returns a formulaStack array. Each of the elements are new filtered columns. We are starting with an empty array [] and after filtering this array is filled with objects. The object provides us information about a column (index) and a formulas array.

Object {column: 1, formulas: Array[1]}

Formula array represent the filter that was added (type and arguments).

To save formulas you would need to access whole collection of formulas. You can do it by referring to formulaCollection object:

hot.getPlugin('Filters').formulaCollection;

This object will give you an information how many columns were given filters:

hot.getPlugin(‘Filters’).formulaCollection.orderStack

and the array of columns

`hot.getPlugin('Filters').formulaCollection.formulas`

Here’s http://jsfiddle.net/aasv1jew/ an example that logs the formulaStack.