columnFilter Plugin - Callbacks available? - Need to SUM col from filtered results.

btBill

Using:
* File: jquery.dataTables.columnFilter.js
* Version: 1.5.1.
* Author: Jovan Popovic

DT: 1.10.dev from git.
Scroller 1.1.1 from git.

I need to SUM a col from the table once it's filtered and display this sum in the footer.

I have click events summing the selected rows, but when the filter is run, it doesnt update correctly.

Right now, I have taken the default columnFilter plugin and just moved the input fields by the dom to a floating div. It works well, but I need to automatically adjust the total based on the fitlering, also, need to uncheck the checkboxes if there are any checked.

I hope this gives enough info, if not, i will provide more. I just feel like I am not using the right method.

Thanks.

allan

Can't say about the column filter plug-in (its 3rd party and not supported by myself), but:

> I need to SUM a col from the table once it's filtered and display this sum in the footer.

In DataTables 1.10 you can simply do:

[code]
var sum = table.column( 0, {filter:'applied'} ).data().reduce( function ( a, b ) {
return a + b;
} );
[/code]

Stick that into a draw callback function and that should do it (changing the column selector for the column you want of course).

Allan

btBill

[quote]allan said: Can't say about the column filter plug-in (its 3rd party and not supported by myself), but:[/quote]

So is the example you provided using the columnFilter plugin? I think there is built in filtering to DT as well, right?

I get 'column' is not a function.
Just trying to determine if the filtering I;m using (the plugin) is causing this.

Thanks.

allan

This example is provided by myself: http://datatables.net/release-datatables/examples/api/multi_filter.html .

The plug-in called "columnFilter" is not - its third party code, kindly provided by Jovan Popovic as noted in the file header you linked to.

I've not tried that plug-in in 1.10 and I've no idea if it will work with 1.10 I'm afraid.

Allan

btBill

Ah, ok. got it.
I kind of have this working now. I had to comment out the Info section that the scroller was outputting to get the fnInfoCallback to fire correctly.

so I have this working now, but....
my headers seem to not line up properly with the columns.
When I click on a row (which fires an fnDraw) it lines up much closer...still not exact, but closer.
Hopefully I will get this squared away today.

Thanks for the response. i will post back with more info as I go.