Searchpanes - table filtering

SatoshiOokami

I would like to ask two questions regarding searchpanes.
It is a very powerful tool and I really like how it works, but there are two things I could not manage to find out.

1) After selecting a value from one panel, is it possible to force a recalculation of the other panels?

Using example here https://datatables.net/extensions/searchpanes/examples/initialisation/collapseStart.html if I choose something from panel 1, I would like to achieve that 2nd and 3rd panels show the values using the current table view.
Concrete example:
I choose Accountant (2) from pane 1, what I would like to achieve is upon filtering recalculate values in panes 2 and 3, leading to pane 2 having values (0) with only Tokyo having 2. And pane 3 having zeroes except 33 and 63.

2) Is it possible for panels to accept external filler value and act accordingly?

I have an app that works with filters that can also come from a different page.
User selects filter and is then redirected to the page with panes, I was able to filter the data in the table, but I would also like panes to highlight the selected value. Is it possible?

sandy

Hi @SatoshiOokami ,

1.
Yes there are 2 config options that are along the lines of what you are describing, take a look at these examples...

• searchPanes.cascadePanes which reduces the options in the other panes according to the table data - example here.
• searchPanes.viewtotal which updates the counts in the other panes according to the table data - example here
• Or you could use them both together - example here

2.
On the page load this could be possible, take a look at the documentation for searchPanes.panes.preSelect

Hope this helps,
Sandy

SatoshiOokami

@sandy Thank you very much for your help!

Both solutions worked perfectly and solved my problem!