Question

162

DataTables - Search in multiple columns with a single drop down

rated 0 times [ 167] [ 5] / answers: 1 / hits: 17208 / 7 Years ago, thu, april 13, 2017, 12:00:00

I'm working with DataTables and i'm trying to search a result in a table with a dropdown. But rather than searching one column, I need to search in two specific columns.

The below syntax works with a single column but how do i do it with multiple columns?

var table = $('#example1').DataTable();

    $(#filter).on('change', function() {

        table.column([4]).search($(this).val()).draw();

    });

I tried doing this but when i use this code it only searches the result in the first column, E.g. 4th Column. and ignores the rest.

        table.column([4,5]).search($(this).val()).draw();

What is the proper method for this?

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

tylerdamiena

Add To Favorites

Follow

Total Points: 139

Total Questions: 90

Total Answers: 118

Location: Liechtenstein

Member since Wed, Dec 8, 2021

3 Years ago

tylerdamiena questions

1 How to access sveltekit session in endpoint?

Tue, May 3, 22, 00:00, 2 Years ago

1 React.js, Each child in a list should have a unique key prop. how to fix if key is already given

Mon, Mar 7, 22, 00:00, 2 Years ago

1 Can`t resolve image.png in styles.css

Fri, Sep 17, 21, 00:00, 3 Years ago

1 Warning: validateDOMNesting(...): < body> cannot appear as a child of < div> in React.js

Wed, May 26, 21, 00:00, 3 Years ago

1 Using readonly on a reactive object

Tue, May 26, 20, 00:00, 4 Years ago

View All

answered 7 Years ago dylondaytond · Accepted Answer

Lets summarize all things here. It will help other people as well.

You can achieve this as follow:

table.column(4).search(this.value).column(5).search(this.val‌ue).draw();

It will perform search on 4 column (4 is index of column), after that it will filter data from 5 column against provided filter value and at the end it will draw the table.

One thing to keep in mind is that Filter is applied on both columns, so both columns must contains matching data.

Here is its filddle

This can be achieved by using fnMultiFilter as it documentation explains:

This plug-in adds to DataTables the ability to set multiple column filtering terms in a single call (particularly useful if using server-side processing). Used in combination with the column sName parameter, simply pass in an object with the key/value pair being the column you wish to search on, and the value you wish to search for.