jQuery DataTables - Iterate over filtered rows and get node / hidden column data

Question

I've been trying to get hold of the hidden column data for all filtered rows, when iterating through them.

        var table = $('#'+dataTableSelector).dataTable();

        table.$('tr', {"filter":"applied"}).each( function () {
            var row = this;
        });

Obviously row refers to the TR instance of the datatable; However, if I access the children elements of the TR, these only contain the visible columns for the row in question.

I want to access all data for the row in question, but when I try to reference the datatable, or table.row(this).node() within the each function it doesn't work - row is not a function.

How can I get all data for the rows for which filters are applied?

Resurgent · Accepted Answer · 2018-04-10 10:18:02Z

9

$(dataTableSelector).DataTable().rows( { filter: 'applied' } ).every( function () {
    var row = this.data();
});

This will get the DataTable instance (where dataTableSelector is your Table ID from your HTML markup), and then get all rows that has a filter applied, and then iterate over all those rows.

Rows that do not match the filters applied (and thus are not visible in your DataTable) will not be within the results returned by rows( { filter: 'applied' } )

You can access each column of the row by row[0], row[1] etc; row will be an array of all columns, including non-visible columns.

edited Apr 10, 2018 at 10:18

answered Apr 9, 2018 at 11:48

Resurgent

5552 gold badges9 silver badges22 bronze badges

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

Comments

colin0117 · Accepted Answer · 2018-04-09 12:31:11Z

0

If you use the DataTables API as @Resurgent suggested, then the data for the hidden columns will be returned still. So use that suggestion, or something like table.rows({filter:'applied'}).data() if want the data in an array.

answered Apr 9, 2018 at 12:31

colin0117

1,5581 gold badge12 silver badges16 bronze badges

Collectives™ on Stack Overflow

jQuery DataTables - Iterate over filtered rows and get node / hidden column data

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related