Replies

• allan Posts: 63,400Questions: 1Answers: 10,452 Site admin

  September 2010

  Try doing it fnInitComplete. The reason being, the XHR is asynchronous, so the $().dataTable() function will complete before the language information has been retrieved - which of course is before it can add the filtering options, which in turn reply on the language.
  
  So fnInitComplete is the way forward I think: http://datatables.net/usage/callbacks#fnInitComplete
  
  Allan
• yanhang Posts: 3Questions: 0Answers: 0

  September 2010

  thanks allan, you're right!
  
  use fnInitComplete callback, it works fine
  
  it seems not a bug, sorry~
• max4ever Posts: 45Questions: 0Answers: 0

  March 2011

  i tried using fnInitComplete, and it still won't work, could you post your working code?
  big thanks
• yanhang Posts: 3Questions: 0Answers: 0

  March 2011

  well,my code is here,it works fine, Allan is right, use fnInitComplete callback, I hope this is useful for you
  
  [code]
  otable_user = $("#htable_user").dataTable(
  {
  "oLanguage": {"sUrl": "../data/zh_ZH.txt"},
  "bJQueryUI": true,
  "bStateSave": false,
  "bPaginate": true,
  "bAutoWidth": false,
  "bProcessing": true,
  "bServerSide": true,
  "sPaginationType": "full_numbers",
  "fnInitComplete": function(){this.fnSetFilteringDelay(500);},//this is callback function
  "sAjaxSource": ajaxsource,
  "aaSorting": [[3,'desc']],
  "aoColumnDefs":[
  {"bVisible": false, "sName":"PK_USER", "aTargets":[0]},
  {"bVisible": true, "sName":"USER_PASSWORD", "aTargets":[1]},
  {"bVisible": false, "sName":"DR", "aTargets":[2]},
  {"bVisible": false, "sName":"TS", "aTargets":[3]},
  {"bVisible": true, "sName":"USER_CODE", "aTargets":[4]},
  {"bVisible": true, "sName":"USER_EMAIL", "aTargets":[5]},
  {"bVisible": true, "sName":"USER_ALLOWLOGIN", "aTargets":[6]},
  {"bVisible": true, "sName":"USER_STARTDATE", "aTargets":[7]},
  {"bVisible": true, "sName":"USER_ENDDATE", "aTargets":[8]}
  ]
  });
  [/code]
• allan Posts: 63,400Questions: 1Answers: 10,452 Site admin

  March 2011

  The reason for this behaviour with sUrl is the asynchronous behaviour of the Ajax call to get the language file, and the way fnSetFilteringDelay works. DataTables can't render the DOM fully until it's got the language file (otherwise - what would it render :-) ), so the call to $().dataTable() will complete before the DOM is in the state you want. fnSetFilteringDelay works by removing the default filtering handle and putting in it's own - but the filtering handle isn't there yet, hence why it needs to go into fnInitComplete - which is fired when the table is fully initialised.
  
  Allan
• max4ever Posts: 45Questions: 0Answers: 0

  March 2011

  i still get almost every key that i type in the search field, submitted with an ajax request(using firebug), even when changing the parameter 500miliseconds with 2000miliseconds
• allan Posts: 63,400Questions: 1Answers: 10,452 Site admin

  March 2011

  Can you show us the code you are using please? Even better - a link... :)
  
  Allan
• max4ever Posts: 45Questions: 0Answers: 0

  March 2011

  i can give you a link with user and password, just can't post it for everyone to read it, can't find the private message button
  
  here is my code (where /scripts/dataTables.addons.js contains the fnSetFilteringDelay() code from http://www.datatables.net/plug-ins/api )
  [code]
  ...
  
  
  
  
  
  
  ...
  
  
  <!--
  var oTable;
  $(document).ready(function() {
  ....
  
  var controller_name = "zona";
  
  oTable = $('#visualizzazione').dataTable(
  {
  "oLanguage": {
  "sUrl": "/lang/dataTables-it_IT.txt"
  },
  //"bStateSave": true,
  "aoColumns": [
  { "sName": "nome", "sWidth": "80%"},
  { "sName": "id", "sWidth": "20%", "bSortable": false, "bSearchable" :false } ],
  "aLengthMenu": [[5, 10, 25, 50, 100, -1], [5, 10, 25, 50, 100, "Tutti"]],
  "sPaginationType": "full_numbers",
  "bJQueryUI": true,
  "bProcessing": true,
  "bServerSide": true,
  "sAjaxSource": "/"+controller_name+"/ajax/",
  "fnDrawCallback": function ( oSettings ) {
  /* Need to redo the counters if filtered or sorted */
  
  for ( var i=0, iLen=oSettings.aiDisplay.length ; i
• allan Posts: 63,400Questions: 1Answers: 10,452 Site admin

  March 2011

  Try replacing line 88 ( }).fnSetFilteringDelay(5000); ) with just "});" - i.e. don't call fnSetFilteringDelay twice.
  
  Allan
• max4ever Posts: 45Questions: 0Answers: 0

  March 2011 edited March 2011

  thanks allan, i tried that it won't work too,
  i just tested that even if i don't use a language file it still won't work
  
  is this order correct ?
  
  
  
  i mean, first dataTables, then the fnSetFilteringDelay script ?
• allan Posts: 63,400Questions: 1Answers: 10,452 Site admin

  March 2011

  Yes that is correct.
  
  I'd suggest adding in a couple of console.log events to the fnSetFilteringDelay function and make sure that they show up in the console when you start typing.
  
  Allan
• max4ever Posts: 45Questions: 0Answers: 0

  April 2011

  hey allan, thank you!
  i found the error, i had an old example or something because
  i had this line
  [code]anControl = $( 'table.dataTables input', _that.fnSettings().aanFeatures.f );[/code]
  
  instead of
  [code]
  anControl = $( 'input', _that.fnSettings().aanFeatures.f );
  [/code]
  
  cheers