How to use multiple filter in DataTables

pow3rITA

Hi! I'm trying to use Datatables in my project. I would like to know if it is possible to use multiple filter for one column. I'll try to do an example:
Considering the Column filtering example link, i would like to have for "Name" column, near the filter a button that allow me to select with a dropdown list three options (for example "equals", "not equals" and "contains"). If i click on "equals" and i write "Airi Satou" i see only 1 record related to "Airi Satou". If i click on "contains" and i write "Br" i see only four records related to "Bradley Greer", "Bradley Greer", "Brielle Williamson", "Bruno Nash".

For the field Age i would like to have another button that allows me to choose four options "<",">","<=",">=" (With similar consideration that i do for field Name).

Filter should works in "AND" ( example: Name equals Airi Satoru AND Age >= 30)

Now the question:
I would like to know if it is possible to "append" dinamically to each filter a different operator ("<",">","equals").

Sorry for my bad english and thanks!

PS: I can't use yadcf

kthorngren

Have you looked at the SearchBuilder extension ?

The other option is to create a Search Plugin to handle the complex searches you want.

Kevin

pow3rITA

Thanks it works very well (I created a new search plugin )!