Answers

• jr42.gordon Posts: 305Questions: 2Answers: 49

  March 2016 edited March 2016

  Try the following code

  dt.column( 'class of column needing update' ).invalidate().render()
  

  If that doesn't work, try

  dt.column( 'class of column needing update' ).cells().invalidate().render()
  

  This clears the cache attached to this column and calls its associated render function.
• allan Posts: 63,534Questions: 1Answers: 10,475 Site admin

  March 2016

  The invalidate methods are probably the best way to go. However, it can depend upon the configuration of the table - we'd really need a link to the page to say for sure.

  Allan
• Mauro26 Posts: 17Questions: 7Answers: 0

  March 2016

  Hi guys i was investigating about the invalidate property, and searching i find some docs...
  With this code is working:

   $("#desc").change(function () {
       debugger;
  
       t.column( 8 ).data()
          .each( function ( value, index ) {
              console.log( 'Data in index: '+index+' is: '+value );
              var tr = $('#example tbody tr:eq(' + index + ') td:eq(8)').html( '4' );
  
              t.column( '8' ).cells().invalidate().render();
          } );
  

  but this is only working for the first page, i have a pagination of ten records the number the tr(11) doesn't take it so it only update the first page, How can i do for update all the rows?
  Regards :)
• allan Posts: 63,534Questions: 1Answers: 10,475 Site admin

  March 2016 Answer ✓

  See the second top FAQ :-)

  Allan
• Mauro26 Posts: 17Questions: 7Answers: 0

  March 2016 edited March 2016

  I resolved with this:

  function CalcDesc(){
  var descuento = $('#desc').val();

       if(descuento != undefined || descuento != 0){
           t.data().each( function ( value, index ) {
                  debugger;
  
                 // var tr = $('#example tbody tr:eq(' + index + ') td:eq(8)').html( '4' );
                   var data = t.row( index ).data();
                   data.descuento = descuento;
              } );
  
           t.column( 'descuento' ).cells().invalidate().render();
       } 
   }
  

  and in the create of the dataTable i put this

                                             "data" : "descuento", 
                                      "width" : "6%",
                                   orderable: false,
                                  "render": function ( data, type, row ) {
                                  var descuento =  $('#desc').val();
                                  var total = row.total;
                                  if (descuento == undefined){
                                       return  '$' + total.toFixed(2);
                                 }
  
                              var result = total - (descuento * total) / 100;
  
                          return  '$' + result.toFixed(2);           
  

  and with that change always i do something in the datatable and exist a discount just add it to the table.

  thanks allan