Multi Filter Same Column

jimbo_s

I need to be able to apply multiple filters to a single column using datatables.

I've been looking at an example they provided here but my requirements are slightly different.

The first column in my table will contain location information, each cell will contain a building name and floor. I want to have two dropdowns that allow users to filter on both of these.

So e.g. 'Show me Building 1 and Second Floor'.

I can get the first dropdown to filter on building, but the second doesn't filter on floor. Here's a link to a demo i'm working with https://codepen.io/qubjohnny/pen/jOPrymJ?editors=1010

Note I have simplified this table and limited it to 6 records, my live table will contain hundreds of records.

kthorngren

Looks like you need to get the value of the other input in your change events. Then combine both into a string and probably use a regex search with column().search().

Another option is to use a Search Plugin. Here is a checkbox search plugin example that will demonstrate something similar:
http://live.datatables.net/rosahuka/1/edit

Kevin