Answers

• naksuriya Posts: 3Questions: 1Answers: 0

  November 2015

  
  var table =  $('#example').DataTable();
  var sum = table.column(4).data().sum();  
  
  alert(sum);
  
  
• jLinux Posts: 981Questions: 73Answers: 75

  November 2015

  Was the last post your resolution?

  You didnt give any detail on what you need.. youre just like "heres code.. fix it"
• naksuriya Posts: 3Questions: 1Answers: 0

  November 2015 edited November 2015

  Sorry for that sir. This is my code. my problem is how to get that class "test" in my api colums?

   
  var table = $('#my_table').DataTable( {
              "bProcessing": true,
               "sAjaxSource": base_url + "core/test",
              "footerCallback": function (row, data, start, end, display) {
              var api = this.api(),
                  data;
  
  
              
             total = api
                      .columns(2 ,  {
                          page: 'current'
                      })
                      .data()
                      .sum();
  
                  
   
  
              // UPDATE FOOTER //
              $(api.column(2).footer()).html( total_number );
  
             
  
          },
  
  
• allan Posts: 63,552Questions: 1Answers: 10,477 Site admin

  November 2015

  The DataTables API isn't going to help a huge amount here (specifically the sum() method) since the data is in the input elements rather than in the data objects for each row - it could be done, but its probably as easy to use a simple for loop.

  First get all of the input elements:

  var inputs = $( 'input.test', api.rows().nodes() );
  

  Then do a for (or $.each) loop over the inputs and sum up their values.

  Allan