datatable中列求和的方法,在DataTables中对过滤的列进行求和

I'm trying to sum the results of filtered columns in DataTables. I've viewed the questions asked on their website and folks have had success using this method.

However, similar code for me produces 'Uncaught TypeError: undefined is not a function."

data = table._('td:nth-child(10)', {"filter": "applied"});

where 'table' is:

var table = $('#dataTable').DataTable({

// my initialization data

});

解决方案

_ (the underscore function) seems to be deprecated in dataTables 1.10.x. In theory it should work with $('#dataTable').dataTable() (the old constructor) but this does not give the expected result (as least not for me).

jQuery.fn.dataTable.Api.register( 'sum()', function () {

return this.flatten().reduce( function ( a, b ) {

return (a*1) + (b*1); // cast values in-case they are strings

});

});

var table = $("#example").DataTable();

$("#example").on('search.dt', function() {

console.log(table.column( 0, {page:'current'} ).data().sum() );

});

would give the same functionality in dataTables 1.10.x as you want in the question header.

table.column( 0, {"filter": "applied"} ).data().sum() works perfectly well also.