Javascript DataTables - filter() function not working as expected

Question

I am using the DataTables javscript library and I'm trying to filter a row out based on if a numerical value is greater than 60.

I'm trying to follow this example: http://datatables.net/reference/api/filter%28%29

The filter code looks like this:

table
    .column( 3 )
    .data()
    .filter( function ( value, index ) {
        return value > 60 ? true : false;
    } )

The problem is all rows are still visible and no filtering has been done at all. Even if my function simply returns false all rows are still visible. What's going on here?

JSFiddle of example

http://jsfiddle.net/1hLcpr3x/

adeneo · Accepted Answer · 2014-12-24 20:10:29Z

16

The example you're linking to is filtering the returning array of the data from the columns, not the rows themselves.

You can verify this by returning the content and logging it

var filteredArray = table.column( 3 )
                         .data()
                         .filter( function(value, index) {
                             return value > 60 ? true : false;
                         })
                         .draw();

console.log(filteredArray);

FIDDLE

This is what the filter method does, it filters the data when you return it with data(), not the rows.

To filter the rows in place, you'd hook into the DataTables plugin, more specifically $.fn.dataTableExt.afnFiltering, and do something like this

$.fn.dataTableExt.afnFiltering.push(
    function (oSettings, aData, iDataIndex) {
        return aData[3] < 60;
    }
);

FIDDLE

Documentation for DataTables filtering

answered Dec 24, 2014 at 20:10

adeneo

319k29 gold badges410 silver badges392 bronze badges

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

3 Comments

Numeron Over a year ago

I have multiple datatables on a page, how do I make sure my custom hooked filter only works with the one I want? Can I derive the table from the passed in settings object?

adeneo Over a year ago

@CanÜrek - what do you mean it's not working? It filters out anyone with an age of 60 or more, and in the last fiddle there are no rows whith persons older than 59, so it's working just fine ?

Azima Over a year ago

sorry to comment this late... but $.fn.dataTableExt.afnFiltering.push is not working for me...I keep getting this Uncaught TypeError: Cannot read property 'push' of undefined in console..

Collectives™ on Stack Overflow

Javascript DataTables - filter() function not working as expected

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related