jQuery DataTable multiple value search

Question

I have situation where I'm filtering values in column "Office" with selectbox where I can select multiple values. For example I want to filter "New York" and "San Francisco" in column "Office" so I expect only first row because it contains both values. My current code shows first row and other row because they contains "New York" or "San Francisco"

Exmple http://live.datatables.net/fadixapi/1/edit?html,js,output

Solved
selected = $("#"+selectId+' option:selected').map(function(){ return "(?=.*"+this.value+")"; }).get(); table.column(2).search("^.*" + search + ".*$",true).draw();

This is difficult to answer without a test case. jsfiddle.net / live.datatables.net — thirtydot
– thirtydot, Commented May 4, 2016 at 12:01

MedMatrix · Accepted Answer · 2016-05-04 13:36:58Z

1

Try this :

table.column(2)
.search("^" + search + "$", column, true, false)
.draw() ;

answered May 4, 2016 at 13:36

MedMatrix

3361 gold badge6 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Matija Kovacek Over a year ago

in .search() what is column variable?

Collectives™ on Stack Overflow

jQuery DataTable multiple value search

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related