How to loop through all rows in DataTables jQuery?

Question

I am using jquery plugin DataTables for building nice table

  var table = $('#example').DataTable({
    "data": source
});

I would like that make an each for all rows in table

Unfortunately this way may be out of date and does't work with new version (it launchs an error)

$(table.fnGetNodes()).each(function () {

});

And this way only works only for visibles rows (10 first rows because other rows are paginated)

 table.each( function ( value, index ) {
    console.log( 'Data in index: '+index+' is: '+value );
} );

Do you known how to loop to all rows please?

what do you mean? do you wish to display all rows? if so, then you can try this: var table = $('#example').DataTable({ "paging":false }); — d_unknown
– d_unknown, Commented Mar 16, 2015 at 13:34
Thanks for answere,no, I don't want to display all rows, I want to dynamically loop all rows in code, even rows which are paginated — Pipo
– Pipo, Commented Mar 16, 2015 at 13:46
maybe you can just used the data.. I mean your source of data that you fill in the dataTable.. I'm not sure.. — d_unknown
– d_unknown, Commented Mar 16, 2015 at 13:53
yes, good idea, but it happens that init dataTable data has been changed by user ( I have a system for allowing user to edit , add, and delete rows without redraw all dataTable). And i wana know things like for exemple what row is the 27th displayed — Pipo
– Pipo, Commented Mar 16, 2015 at 14:15
Unfortunately this way may be out of date and does't work with new version (it launchs an error) What is the error that it throws? — Nico
– Nico, Commented Mar 16, 2015 at 19:29

Pipo · Accepted Answer · 2018-11-15 10:53:25Z

45

I finally found:

 var data = table.rows().data();
 data.each(function (value, index) {
     console.log(`For index ${index}, data value is ${value}`);
 });

edited Nov 15, 2018 at 10:53

answered Mar 16, 2015 at 23:58

Pipo

5,7718 gold badges37 silver badges71 bronze badges

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

4 Comments

starbeamrainbowlabs Over a year ago

Warning: This only iterates over the data itself that was passed in to dataTables - so any HTML you give it will be a string in this method.

natsumiyu Over a year ago

How to get specific column values only?

natsumiyu Over a year ago

I only get the first page data. How to get the next page ?

Enriqe Over a year ago

You can do it even easier: var data = table.data();

Athman · Accepted Answer · 2015-06-09 15:01:15Z

13

Datatables have an iterator for each row rows().every() with this referring to the context of the current row being iterated.

tableName.rows().every(function(){
    console.log(this.data());
});

edited Jun 9, 2015 at 15:01

answered Jun 9, 2015 at 8:33

Athman

5946 silver badges15 bronze badges

1 Comment

Ashok Gurram Over a year ago

By this we will get rows of current pager. How can i get all pagers data.

Mohd Abdul Mujib · Accepted Answer · 2016-04-21 14:29:56Z

7

If you are using the legacy DataTables then you can get all the rows even the paginated ones, as shown below...

table.fnGetNodes(); // table is the datatables object.

So we can loop through the rows by using .each() method provided by jQuery.

jQuery(table.fnGetNodes()).each(function () {
// You can use `jQuery(this).` to access each row, and process it further.            
});

edited Apr 21, 2016 at 14:29

answered Apr 20, 2016 at 13:29

Mohd Abdul Mujib

14.2k8 gold badges72 silver badges93 bronze badges

Comments

Asad Naeem · Accepted Answer · 2023-02-02 06:17:43Z

2

for example, this data has three fields UserID, UserName and isActive and we want to show only active users The following code will return all the rows.

var data = $('#myDataTable').DataTable().rows().data();

We will print only active users

data.each(function (value, index) {
  if (value.isActive)
  {
     console.log(value.UserID);
     console.log(value.UserName);
  }
});

edited Feb 2, 2023 at 6:17

answered Nov 21, 2019 at 10:13

Asad Naeem

6579 silver badges15 bronze badges

Collectives™ on Stack Overflow

How to loop through all rows in DataTables jQuery?

4 Answers 4

4 Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

4 Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related