Question: How to search/filter multiple columns with one search field about datatable HOT 2 CLOSED

This is possible, what you want to do is something like:

filters: {
    _1: function (data, text) {
        for (var i = 0; i < data.length; ++i) {
            // text is always uppercase, you can obviously perform different checks.
            if (new String(data[i]).toUpperCase().indexOf(text) !== -1) {
                return true;
            }
        }
        return false;
    }    
}

The _1 key is what you want here for the lambda, this should give you an input filter on the first column. The easiest way if you want to move it / make it span multiple column is to do it after the datatable via JS. data will contains the whole row, which in your case is a standard JS array.

I cannot test this code right now, so it may not work out-of-the-box, but you get the idea! Feel free to ask if you need more information.

from datatable.

Thank you very much for your reply and solution. I did, however, write my own search function in the meantime that iterates the entire data array, re-assigns it to the table's data array, refreshes the table, and then resets the per page option. It seems to work fine...

from datatable.