CODEWITHSUNDEEP
javascriptjquerydatatablesyadcf
Oskar Westmeijer
Oskar Westmeijer

Reputation: 137

yadcf: exFilterColumn function is not working

I'm using datatables and yadcf on my website. Everything is working fine. In some cases I want to prefilter a column. 

yadcf.init(oTable, [ {
                        column_number : 1,
                        filter_default_label : "",
                        filter_reset_button_text : false,
                        filter_type : "multi_select",
                        select_type : 'select2'

                    }, {
                        column_number : 2,
                        filter_default_label : "",
                        filter_reset_button_text : false,
                        filter_type : "multi_select",
                        select_type : 'select2'

                    }, {
                        column_number : 3,
                        filter_default_label : "",
                        filter_reset_button_text : false,
                        filter_type : "multi_select",
                        select_type : 'select2' 

                    }, {
                        column_number : 5,
                        filter_default_label : "",
                        filter_reset_button_text : false,
                        filter_type : "multi_select",
                        select_type : 'select2'

                    }, {
                        column_number : 6,
                        filter_default_label : "",
                        filter_reset_button_text : false,
                        filter_type : "multi_select",
                        select_type : 'select2'

                    } ]);

Until this point everything works fine. But when I add:

yadcf.exFilterColumn(oTable, [[3, 'WNC402']]);

there does not appear any filter. The console output error is:

jquery.dataTables.yadcf.js:688 Uncaught TypeError: selected_value.join is not a function
    at yadcfMatchFilterString (jquery.dataTables.yadcf.js:688)
    at Object.exFilterColumn (jquery.dataTables.yadcf.js:3792)
    at HTMLDocument.<anonymous>
    at i (jquery-2.2.4.min.js:2)
    at Object.fireWith [as resolveWith] (jquery-2.2.4.min.js:2)
    at Function.ready (jquery-2.2.4.min.js:2)
    at HTMLDocument.J (jquery-2.2.4.min.js:2)

the site still loads properly and I even can set the filters manually. But the function should do the job.

my datatables version is: 1.10.12

my yadcf version is: 0.8.9

some links:

https://datatables.net/

https://github.com/vedmack/yadcf

Thank you.

Upvotes: 0

Views: 1630

Answers (3)

Murat &#199;apanoğlu
Murat &#199;apanoğlu

Reputation: 1

I have solved the issue with jQuery in init complete event of datatable.

$("#yadcf-filter--kt_datatable-28").val("Active");
$("#yadcf-filter--kt_datatable-28").trigger("change");

Upvotes: 0

Daniel
Daniel

Reputation: 37061

Please read the docs and the usage example of filtering mutiselect column

yadcf.exFilterColumn(oTable, [[0, ['Some Data 1','Some Data 2']]]); // for pre filtering multi select filter you should use array with values (or an array with single value)

Since its a multi select filter you have to provide the filter value inside an array.

Upvotes: 0

Oskar Westmeijer
Oskar Westmeijer

Reputation: 137

ok I found something. Instead using yadcf's exColumnFilter function, I used Datatables search function.

oTable.columns(3).search("WNC402").draw();

works like a charm. The Filter appears now and is even removable in my case.

I hope this will also help someone else.

Upvotes: 0

Related Questions