Replies

• rduncecb Posts: 125Questions: 2Answers: 28

  September 2017

  When you select a new user you can use clear to remove the data from the table and then row.add / rows.add to add the new rows.
• jibranb Posts: 8Questions: 3Answers: 1

  September 2017 edited September 2017

  Thanks for the response, @rduncecb.

  I got your comments working, but once I start interacting with the new data (editing, reordering) I get pretty strange results. Rows start disappearing. It's seem old data is still being expected or referenced.

      // vars
      var $certs_table = $( '#user_certs' );
      var ajax_url = "ajax/get-certs.php?id=" + user_id;
  
      // is certs table already a datatable?
      if ( $.fn.dataTable.isDataTable( $certs_table ) ) { 
  
          // yes, let's make our own call
          console.log( 'reloading certs data...' );
  
          // get datatable api        
          $certs_table = $certs_table.DataTable();
          
          // clear it out
          $certs_table.clear();
          
          $.post( ajax_url, function( response ) {
              
              console.log( response );
              
              if( response && response.data ) {
                  
                  $certs_table.rows.add( response.data ).draw();
  
              }
              
          });
  
          // move along
          return;
      }
  

  It might be important to note that when I initialize both the Editor and the DataTable, their AJAX URLs are using the ID of the very first user. This seems problematic. I'm not re-initializing on subsequent calls and not sure how to reset the user_id.

      cert_editor = new $.fn.dataTable.Editor( {
          ajax: ajax_url,
          table: $certs_table
              ...
      } );
  
      var certs = $certs_table.DataTable( {
          dom: 'Bfrtip',
          ajax: ajax_url,
               ...
      } );
  
  

  Thoughts?
• rduncecb Posts: 125Questions: 2Answers: 28

  September 2017

  You've got a mix here, you're supplying ajax and also loading data yourself with post. Personally, I would not load rows myself and leave it all up to datatables. Take a look at ajax.url for changing your URL. You could just change the URL, tell the datatable to reload the data and it's all taken care of without using clear