footer callback for sum and total sum by using server-side

footer callback for sum and total sum by using server-side

BhushanMBhushanM Posts: 1Questions: 1Answers: 0

I need footer callback for sum row and a total sum of that column.
How to fetch total sum.
I use server-side , fetch data from server

Answers

  • alderhernandezalderhernandez Posts: 33Questions: 11Answers: 1
    edited October 2017

    hi. use rowCallBack

    $('#tblArticulos').DataTable({
            "processing": true,
            "serverSide": true,
            "columnDefs": [{
                "targets": [4, 8, 9, 10],
                "orderable": false,
                "visible": false
            }],
            "lengthMenu": [[10, 25, 50, 100], [10, 25, 50, 100]],
            "pagingType": "full_numbers",
            "ajax": {
                "url": "LoadArticulos",
                "type": "POST",
                "datatype": "json",
                "data": {
                    CB: $("#txtCBarra").val()
                }
            },
            "columns": [
                { "data": "miColumnToSum", "name": "CodigoDeBarras", "autoWidth": true }
                 //etc etc.....
            ],
            "rowCallback": function( row, data, index ) {
               var sum = 0;
               sum += data.miColumnToSum;
               //DO WHAT YOU WANT
            }
        });
    
This discussion has been closed.