Answers

• classic12 Posts: 228Questions: 60Answers: 4

  November 2017

  I tried this event but this is not on the initial draw only redraws.

      tableDataChanged.on( 'draw', function () {
      alert( 'Redraw occurred ' );
      } );
  
• classic12 Posts: 228Questions: 60Answers: 4

  November 2017

  I tried this

  $('#dtDataChanged').dataTable( {"initComplete": function(settings, json) {
      alert( 'DataTables has finished its initialisation.' );
     //  if (urlDeal !== 'null') { alert('does exist urlDeal = '+ urlDeal) ; $('#searchDeal').val(urlDeal);}
    }
  } );
  

  but gives error

  TypeError: url.lastIndexOf is not a function. (In 'url.lastIndexOf('/')', 'url.lastIndexOf' is undefined).
  line 3923 column 49
• classic12 Posts: 228Questions: 60Answers: 4

  November 2017

  This call happens but seems to be before the re-draw so I dont get the text in the box/

          fnDrawCallback: function() {
          //alert( 'ajax done in options' );
          if (urlDeal !== null) { alert('urlDeal = '+ urlDeal) ; $('#searchDeal').val(urlDeal); urlDeal = null}
          }, 
  
• allan Posts: 63,531Questions: 1Answers: 10,474 Site admin

  November 2017

  TypeError: url.lastIndexOf is not a function. (In 'url.lastIndexOf('/')', 'url.lastIndexOf' is undefined).

  Sounds like urlDeal is probably undefined at that point.

  I tried this event but this is not on the initial draw only redraws.

  You need to add it before you initialise the DataTable.

  $('#myTable')
    .on( 'draw.dt', function ... )
    .DataTable( {
       ...
    } );
  

  However, xhr should be working. If it isn't please link to a test case showing the issue.

  Allan
• classic12 Posts: 228Questions: 60Answers: 4

  November 2017

  Hi Allan

  where do I place the code.
  on the initialisation or on document ready ?

  $('#dtDataChanged')
      .on('xhr.dt', function ( e, settings, json, xhr ) {
          alert('loaded');
  // pass in urlDeal to the search box id and do the search
  if (urlDeal !== 'null') { $('#searchDeal').val(urlDeal);}
      } )
  

  Cheers

  Steve Warby
• allan Posts: 63,531Questions: 1Answers: 10,474 Site admin

  November 2017

  Inside the document ready function, before you initialise the DataTable.

  Allan
• classic12 Posts: 228Questions: 60Answers: 4

  November 2017

  Hi Allan

  http://surplusanywhere.com/surplusAnywhere7

  $(document).ready(function(){
  $('#dtDataChanged')
      .on('xhr.dt', function ( e, settings, json, xhr ) {
          alert('loaded');
      } );
      });
  
• allan Posts: 63,531Questions: 1Answers: 10,474 Site admin

  November 2017

  You aren't using the ajax option of DataTables to load the data. It took me a little while to see it, but you are Ajax loading it yourself:

  getQuoteDetails=function(){
    req = Ajax("http://www.surplusanywhere.com/php/getFiles.php", "GET", 'someData',quotesReturned);  
  }                
  

  So yes, it is correct that DataTables will not trigger its xhr event.

  Allan
• classic12 Posts: 228Questions: 60Answers: 4

  November 2017

  Thanks,

  The event I need is when the Ajax call has loaded all the data.
  What is the correct code and where do I place it?

  Once this happens I check if the url has a deal parameter and perform a search on the dealID column.
• allan Posts: 63,531Questions: 1Answers: 10,474 Site admin

  November 2017

  Where do you define your Ajax function? I'm presuming that the fourth parameter is a callback function that is passed in the data, so that is where you would have the data and be able to access it. quotesReturned in this case.