How to get searched or filtered data?

akibar

Hi,

I just find this great tool and have a question. I have a table with filter and search inputs, each row has a checkbox at first column. The table also has "Select All" checkbox.

When user select the "Select All" checkbox all checkboxes should be selected. i did this with:
var aTrs = oTableLocal.fnGetNodes();
for ( var i=0 ; i

allan

Hi akibar,

Try this plug-in function which I've just bashed together: http://datatables.net/plug-ins#api_fnGetFilteredNodes

Hopefully it will do exactly what you are looking for.

Allan

akibar

Hi allan,

That is exactly what i am looking for.

Thank you,

akibar

maater

@allan @akibar This plugin seems to have been deleted. Can either of you guys share the code here? Thanks.

allan

Just changed location: http://datatables.net/plug-ins/api#fnGetFilteredData

Allan

maocampoq

I solved a similar problem by using the footer call back

"fnFooterCallback": function (nRow, aaData, iStart, iEnd, aiDisplay)

aiDisplay has the list of all elements currently filtered, so i simply iterate on aaData till the length of aiDisplay and do whatever i want, in my case i just want to get the Sum of column 1 of all currently filtered rows

var total = 0;
for (var i = 0; i < aiDisplay.length; i++) {
var number = aaData[aiDisplay[i]][1] * 1;
total += number;
}

robertbrower

Where is http://datatables.net/plug-ins/api#fnGetFilteredData ?

allan

fnGetFilteredData is a redundant plug-in now since the underscore function which is built into DataTables 1.9 will do the same thing:

[code]
table._('tr', {"filter":"applied"});
[/code]

Allan

robertbrower

Thanks Allen.

I solved my problem by using the dollar sign API method in conjunction with fnGetData, fnUpdate, and fnRedraw. Here's my code for anyone interested.

In my case I have 2 checkboxes in the first column header. They both have the toggleAll class applied. One is checked, the other is not. When the user clicks the checked checkbox, then all filtered rows should be checked. When the user clicks the unchecked checkbox then all filtered eows should be unchecked.

My HTML table contains "unchecked" in the first cell of each row. Then I initialize my plugin:



settings.$dataTable = $this.find("#TrendParametersTable").dataTable({
"bJQueryUI": true
, "sPaginationType": "full_numbers"
, "sScrollY": "250px"
, "aoColumnDefs": [
{
"aTargets": [0]
, "bSearchable": false
, "fnRender": function (obj) {
var html = '

allan

Good to hear that did the business for you.

> Note... fnUpdate and fnDraw are not needed here since the action of clicking on the checkbox in the first place checks it.

For live DOM elements this is absolutely correct - like checkboxes. However, if you were manipulating plain text and wanted filtering / sorting to work with the updated data, you would need to use fnUpdate, so DataTables knows that something has changed.

*edit* I should say that it would be nice not to need fnUpdate at all, but until DOM mutation events ( http://www.w3.org/TR/DOM-Level-2-Events/events.html#Events-eventgroupings-mutationevents ) are supported by the vast majority of browsers in use, we are stuck with it... One day... :-)

Allan

macuser

Hi Allan,

Can you please link me to http://datatables.net/plug-ins/api#fnGetFilteredData, as we still use Datatables 1.8.2.
I am sure there would be more users who are still dependent on DT 1.8.2.
So it will be useful if you could get back that page.

Thanks,
Swad

Malcolm

Wayback machine to the rescue: http://web.archive.org/web/20110623214415/http://datatables.net/plug-ins/api