Replies

• GregP Posts: 487Questions: 8Answers: 0

  September 2011

  Based on visual inspection, the first time it's being fired is when you set oTable variable within your function; the second is when you then call that 'getDatatable()' function. Or it could be that one of those is when you redeclare oTable as datatable. Not 100% sure, but certainly there is redundancy in the way you're creating and caching the table, and that's where your problems stem from.
  
  The way you've set up your caching is not necessary; just put the whole "var oTable = $('#katalog').dataTable({ ... })" block into the document ready function, and Bob's your uncle!
• basejumper Posts: 6Questions: 0Answers: 0

  September 2011

  GregP thank you for your advice, but I've already tried it. Unfortunately it doesn't change situation: loading still happens twice :(
• GregP Posts: 487Questions: 8Answers: 0

  September 2011

  did you get rid of 'datatable = oTable' also? Since you're not even using the datatable variable anywhere, that's a safe one.
  
  I wonder if the filter is getting triggered? The handler itself seems fine, but is it possible that it's getting fired somehow?
• basejumper Posts: 6Questions: 0Answers: 0

  September 2011

  I'm using this variable to call datatables methods (for example fnReloadAjax() or fnAdjustColumnSizing()) from other functions (I set oTable to some other variable datatable, declared globally, so I can use it globally, it was very usefull to automatically reload datatable in Ajax callback after data have been modified ). I've tried now to configure datatable as you told without this variable and still it didn't help :( This filter and two other buttons I've put on upper paginator's place works fine and it doesn't matter, I've tried the default configuration and the problem remains the same :( Thnx for your advices.
• basejumper Posts: 6Questions: 0Answers: 0

  September 2011

  I think it will be easier for all of us if I modify a bit my first comment with code to show the most default configuration with this problem, cause now we are seeking for a problem in my modifications :)
• GregP Posts: 487Questions: 8Answers: 0

  September 2011

  I'm at a loss. That looks like a pretty solid default configuration.
  
  If you use Firebug or Developer Tools to monitor network activity, is there only one request for the data?
• basejumper Posts: 6Questions: 0Answers: 0

  September 2011 edited September 2011

  There are two requests: one standard request to Ajax source, something like http://localhost/newsletters/getdata.php?_=1316161798370 (Firebug Console tab, as a Response we get here our db data) ; the second one can be seen in Net tab, it looks like GET viewer.php (my file with html + datatables configuration, from php there is only extension :) there's a cookie being set etc., as a Response comes whole viewer.php document source ). I don't know, maybe it's a normal situation, cause the first table empty data loading could be seen only in very short period of time, maybe you and other doesn't turn on this attention :D Have you tried to put something like alert(oSettings.aiDisplay.length); somewhere in datatables configuration, for example in "fnDrawCallback": function ( oSettings ) {} ? In my case this alert is called two times, first time it shows me "0", for the second time situation had been normalized and it shows me "51" - correct record count of my table :) Why does it happen two times, I don't know :)
• GregP Posts: 487Questions: 8Answers: 0

  September 2011

  I'm still at a loss, but I can say that in 'default' configuration, the request should not happen twice.
• allan Posts: 61,972Questions: 1Answers: 10,160 Site admin

  September 2011

  Oddly enough, this hasn't really come up before, but now two threads in the same day :-). Basically the draw happens the first time when the Ajax request goes out initially so DataTables can show the 'Loading...' message (which you can set with http://datatables.net/ref#oLanguage.sLoadingRecords - you aren't seeing this due to the backwards compatibility that DataTables has built in - just add in the sLoadingRecords parameter and it should work okay).
  
  Then a second draw is done the data is loaded - hence two calls to fnDrawCallback.
  
  If you want to make the call only once - when the table is fully done, then fnInitComplete is the one for you. Alternatively there is an internal market which can be used to check if you want to, but it is internal and thus subject to change (although not going to in 1.8.x...!).
  
  Regards,
  Allan
• basejumper Posts: 6Questions: 0Answers: 0

  September 2011

  Thank you allan, GregP for your advices and explanations! Still I haven't succeeded to set sLoadingRecords parameter (I've set it, but still it doesn't shows in the first table draw). During the first table draw programm is showing sEmptyTable parameter if it's defined, if it's not defined - datatables shows me sZeroRecords parameter :D If we have situation with default configuration when oLanguage isn't set or in oLanguage both sEmptyTable and sZeroRecords aren't defined - I can see default (No data available in table) sEmptyTable message.
• jamov Posts: 5Questions: 0Answers: 0

  May 2014 edited May 2014

  Old post I know, but ran into this myself with an ajax source. Building on some of the comments above, I used the finInitComplete call to set the the fnDrawCallback that way I know the datatable is initialized

      "fnInitComplete": function(oSettings, json) {                             
           oSettings.fnDrawCallback = alert('redraw');
      }
  

  Update:
  Seems I got over zealous with the above, while the alert was executed on fnInitComplete, I later realized that subsequent redraws did not make the call and unfortunately was not able to find a syntax that would allow me to set the drawback function after initialization.
• allan Posts: 61,972Questions: 1Answers: 10,160 Site admin

  May 2014

  That might have worked in very old versions of DataTables, but it certainly won't in newer versions. The settings object is considered to be private and show never be written to unless you are very familiar with how DataTables works internally.

  In this case I would suggest using the public API and add a draw event handler:

  initComplete: function () {
    this.api().on( 'draw', function () {
      alert( 'draw' );
    } );
  }
  

  Allan