I have multiselect filters on 4 columns. Is there a way to update the filter values of other 3 filter values based on the selection of the first filter value (the other 3 filters should only have values that are present in the table at that point). I have seen refreshfilter() function, but not sure on what event that function should be called.
By default, filters don’t depend on each other in any way. Each filter has options with id/value pair which match the values in the column.
The only way to get the needed behaviour is to set your own dependency between options.
-
the only thing that can be extracted from the “master” filter is column values
-
for “slave” filters, it assumes custom options (data collections with required API) with some additional parameter to rely on
-
a data collection has to be linked with the first filter:
Thanks for the code, it was great help. But, my data is huge and the data table freezes to load the filters.
Unfortunately, this solution is the closest to your requirements we can suggest so far.
A similar pattern is provided by default for the server-side filtering: as both filtering and sorting are performed on the server side, only the data that is currently available will be pushed to options: https://webix.com/snippet/eb223002
Again, it is possible to set your own options for one or more columns and they will be always available.