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

imnkk

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.

daniel_r

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

allan

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

markMathews1989

@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:

function columns() {
    //Drop down filter for column 3
    table.columns([3]).every( function () {
        
    } );

    //Drop down filter for column 4
    table.columns([4]).every( function () {
        
    } );
}

Everything in your function I do is the same other than passing a column.

kthorngren

@markMathews1989 , The columns() API can use a column-selector to choose which columns to act on. There are lots of options but you could use and array table.columns([3, 4]) or a class, etc.

Kevin