How to re-bind filter dropdown after filter table against another dropdown
How to re-bind filter dropdown after filter table against another dropdown

Hello,
I have to make my HTML table fully supported with multi-level filtration.
In the attachment, we have dropdowns related to each column, my problem is How to update the values of rest of dropdown list, if I am using a column's drop-down to filter my table.
Like here if I am filtering AccountNumber- with a value 2003131352 Then the Service-type column's filter dropdown should not contain electric.
Please help me. Sorry, my English is poor.
This discussion has been closed.
Answers
In case you want "cumulative filtering" you can try using my yadcf plugin for datatables, see relevant example:
http://yadcf-showcase.appspot.com/cumulative_filtering.html
See also here which is the same as this example but it updates the options.
Also worth trying out Daniel's YADCF which is excellent.
Allan
@allan, how can I do this on only 2 columns? I have a similar function on the drop down list, only I create 2 filters vs filters on all the columns:
For example:
Everything in your function I do is the same other than passing a column.
@markMathews1989 , The
columns()
API can use acolumn-selector
to choose which columns to act on. There are lots of options but you could use and arraytable.columns([3, 4])
or a class, etc.Kevin