I have a button that apply filter to jquery datatable
$("#buttonFilter").button().click(function() {
if (lboxColor.val() != null) {
jqTable.fnFilter($("option:selected", lboxColor).text(), 1);
}
});
It shows me for example 47 rows from 60. I tried .fnGetData() and fnGetNodes() but it shows me all rows, but not filtered. How could I get 47 rows?
I've been searching for about an hour, for anyone using DataTables 1.10+ if you want to get the filtered (better term: "searched") rows:
var table = $('.table').DataTable({...});
function selectOnlyFiltered(){
var filteredRows = table.rows({filter: 'applied'});
}
For datatables 1.9 and later this solution works:
myDataTableHandle = $('#example1').dataTable(...);
...
...
var myFilteredRows = myDataTableHandle._('tr', {"filter":"applied"});
and you won't have to include a separate api plugin. :)
{"filter":"applied"} code only gives me 10 values.fnRecordsDisplay() does give the correct value of 45,048 so there is a way to get all the filtered nodes/values. Does anyone know the REAL answer?bDeferRender is turned on. See similar issue hereJust in case you want a collection of nodes (DOM elements) just like fngetNodes(), you can use the '$' instead of the '_' like this table.$('tr', {"filter":"applied"});
the '_' returns a collection of 'TR' (html elements).
In current versions selector-modifier uses a slightly different set of properties.
var table = $('#example').DataTable();
var rows = table.rows({"search" : "applied"});
And you can iterate over the cell data like this:
table.rows({"search":"applied" }).every( function () {
var data = this.data();
});
Some helpful links:
For those struggling to get data from only one column AND only from visible rows: you can actually combine the "selectors" like this
var total = api
.column(2, { search: 'applied' }) // <-- only 3rd column && only visible after applied search
.data()
.reduce(function (a, b) {
return floatVal(a) + floatVal(b)
}, 0)
I also notices several sources stating { page: 'current' } would be the right selector for currently visible rows, but this one actually gives you the rows visible after a possible pagination.
For those who are interested, this is a concrete usecase.
/**
* Select all the elements of the datatable which match the current user
* search (or all if no search).
*/
function dtable_selectAll()
{
idTable = 'myDataTable';
var rows = $('#' + idTable).dataTable()
.$('tr', {"filter":"applied"});
var oTT = TableTools.fnGetInstance(idTable);
$(rows).each(function (index, el){
oTT.fnSelect(el);
})
}
Hope it helps.
like if work for you
var data = []
table.rows({"search":"applied"}).every(()=>data.push(this.data()))
console.log(data)
