Footer sum using data attribute

palomarziano

Hi, I would like to use the footer function to get the sum of a column. In the column I display the the number with some html style and if I sum the values I get an error. In the cell I put the integer value on two data attributes, "data-sort" and "data-csv" and I would like to use this value to obtain the sum.
I tried to put the name of the data attribute, with and without "data-" and also with "@" but nothing.
ex. pageTotal = api.column(i).data('data-csv')......
Could you help me?

kthorngren

column().data() won't have access to the nodes. Try column().nodes() to get the td. You can then get the data attributes of the td.

Kevin

palomarziano

Thanks for your reply.
I tried to use column().nodes but I don't understand how to use it.
For exemple if I use
api.column( i ).nodes().to$().data('csv')
I get only the first row value.

kthorngren

This example show a couple different loops you can use:
http://live.datatables.net/wifavihe/1/edit

One uses jQuery each() and the other uses reduce() to sum the data value.

Kevin

palomarziano

thank but if I use your code inside the footer callback function I get an error

kthorngren

Please provide a test case (update mine if you want) of what you are trying so we can help debug.
https://datatables.net/manual/tech-notes/10#How-to-provide-a-test-case

Kevin

palomarziano

I find the solution, thanks for your suggestion!
Here the solution:
$(document).ready( function () { table = $('#example').DataTable({ "footerCallback": function ( row, data, start, end, display ) { var api = this.api(), data; col = 0; total = api.column(col, { page: 'current'}).nodes().reduce( function ( a, b ) { return a + $(b).data('attribute'); }, 0 ); } });

http://live.datatables.net/dobapuru/1/