By using this code I can loop thru all DataTable rows and show the row values:
var table = $('#Example').DataTable();
table.rows().every(function(){
console.log(this.data());
});
But how can I get the value only from cell 3 on each row?
-
does cell 3 have a class?Andrew Daly– Andrew Daly2019-07-22 15:52:49 +00:00Commented Jul 22, 2019 at 15:52
-
cell 3 was an example, it can be whatever cell I wantRoly– Roly2019-07-22 15:56:31 +00:00Commented Jul 22, 2019 at 15:56
-
@AndrewDaly and no it does not have a classRoly– Roly2019-07-22 15:57:37 +00:00Commented Jul 22, 2019 at 15:57
-
var dataRow = table.rows( ':nth-child(3)' ).data();Andrew Daly– Andrew Daly2019-07-22 15:59:00 +00:00Commented Jul 22, 2019 at 15:59
Add a comment
|
2 Answers
After trial and error this is what ended up working for me:
var table = $('#dtBasicExample').DataTable();
table.rows().every(function(){
var Row=this.data();//store every row data in a variable
console.log(Row[3]);//show Row + Cell index
});
Comments
Use columns().data()
let table = $('#example').DataTable();
let values = table.columns(2) // DataTables is zero-based
.data()
.eq(0); // Convert to 2D array
console.log(values);
