CODEWITHSUNDEEP
jqueryregexdatatables
Zen
Zen

Reputation: 25

datatables.net regular expression filter on two columns

I'm using jQuery Datatables and I want to use a regular expression on two columns to filter data in the table.

I have code for filter column 5 but I'd like it to filter columns 5 & 6 both. Is it possible?

$("#venuefilterit li").click(function(e) {
                var venue = $(this).text();
                var venueFilterRegex = "^\\s*"+venue+"\\s*$";
                oTable.fnFilter(venueFilterRegex,5,true,false);
});

I saw something similar to what I need at jQuery DataTables Filtering for Specific Columns Only - but can't get it to work with regex.

Any ideas?

Upvotes: 2

Views: 3231

Answers (1)

yosafatade
yosafatade

Reputation: 185

Yes you can use fnMultifilter or if you use fnFilter, you must call this function as many times as the column you want to filter. For example you want to filter column 5 and 6 so in your code: will be:

$("#venuefilterit li").click(function(e) {
  oTable.fnFilter(venueFilterRegex,5,true,false);
  oTable.fnFilter(venueFilterRegex,6,true,false);
}

If you want to use 'fnMultifilter' you can check this fnMultiFilter

Upvotes: 2

Related Questions