Replies

• Chemon Posts: 19Questions: 0Answers: 0

  December 2012 edited December 2012

  Ok, i think i am on the right track.
  Please Allan, take a look, is long but is well explained, is easy for u, just 2 questions at the end.
  [code]
  var debug = [];
  $(document).ready(function() {
  var oTable;
  $('#dynamic').html('');
  
  function initTabla( json )
  {
  debug['json'] = json;
  oTable = $('#example').dataTable({
  /*"bProcessing": true,
  "bServerSide": true,
  "sAjaxSource": "http://gestionmimascota.loc/pedidos/cargaDatos",
  "sServerMethod": "POST",*/
  "aaData": json.aaData,
  "aoColumns": json.aoColumns,
  });
  oTable.fnSettings().oFeatures.bProcessing = true;
  oTable.fnSettings().oFeatures.bServerSide = true;
  oTable.fnSettings().oFeatures.sAjaxSource = "http://gestionmimascota.loc/pedidos/cargaDatos";
  oTable.fnSettings().oFeatures.sServerMethod = "POST";
  debug['oTable'] = oTable;
  }
  
  $.ajax( {
  "dataType": 'json',
  "type": "POST",
  "url": "http://gestionmimascota.loc/pedidos/iniciaTabla",
  "success": initTabla,
  "error": function(){ alert("Error en la inicializacion de la tabla")}
  } );
  });
  console.log( debug );
  [/code]
  
  I am doing out of datatable creation
  [code]
  ...
  oTable.fnSettings().oFeatures.bProcessing = true;
  oTable.fnSettings().oFeatures.bServerSide = true;
  oTable.fnSettings().oFeatures.sAjaxSource = "http://gestionmimascota.loc/pedidos/cargaDatos";
  ...
  [/code]
  because if u define these properties when u create the table
  [code]
  oTable = $('#example').dataTable({
  "bProcessing": true,
  "bServerSide": true,
  "sAjaxSource": "http://gestionmimascota.loc/pedidos/cargaDatos",
  "sServerMethod": "POST",
  "aaData": json.aaData,
  "aoColumns": json.aoColumns,
  });
  [/code]
  u get a double AJAX call
  1 from
  [code]
  $.ajax( {
  "dataType": 'json',
  "type": "POST",
  "url": "http://gestionmimascota.loc/pedidos/iniciaTabla",
  "success": initTabla,
  "error": function(){ alert("Error en la inicializacion de la tabla")}
  } );
  [/code]
  and other from _fnInitialise private datatable function that execute a Ajax call to get the data from the "sAjaxSource": "http://gestionmimascota.loc/pedidos/cargaDatos"
  but the point is, i already sent it on the normal call
  $.ajax( ...."url": "http://gestionmimascota.loc/pedidos/iniciaTabla", ... )
  "aaData": json.aaData,
  "aoColumns": json.aoColumns,
  
  My question are
  ¿ i am focusing it in the right way ?
  
  there are 2 ways to do it,
  1.- send column and data info and draw the table with just 1 AJAX call like this example.
  2.- send column info on first AJAX call to initialice datatable options and then another AJAX call to get the data from the server and draw the full datatable, so 2 AJAX call.
  Are there big diference between both ways ? or i am getting crazzy ? xD
  Sorry, i am relatively new on this.
  I hope someone can answer to these questions and it be helpfull for others.
  Ty.
• allan Posts: 63,389Questions: 1Answers: 10,450 Site admin

  December 2012

  > ¿ i am focusing it in the right way ?
  
  No :-). Manipulating the settings object after initialisation is absolutely not supported, nor recommended unless you are really sure of what you are doing and know the DataTables code extremely well. I wrote it and would hesitate!
  
  Secondly, if you are using DataTables in server-side processing mode, you don't need to make your own Ajax calls - DataTables will do them itself. Anything else will likely lead to a lot of confusion. Why do you want to do it the way you have? If you are using server-sid processing, you _must_ implement the protocol described here: http://datatables.net/usage/server-side
  
  Allan
• Chemon Posts: 19Questions: 0Answers: 0

  December 2012 edited December 2012

  Yes yes Allan, i need to learn.
  
  I need to inicialice aoColumns properties on the first call ( sEcho = 1 ). aoColumns properties depends of user so on first call, i sent aoColumns info. dont need to send it anymore.
  Just need to send it if user privileges changes, like for example if an admin gave right to see a column he cant see before.
  I will study how do this after, i will do it with timestam, saving it and checking if it changed on each call. If it changed, i have to resend the new aoColumns properties.
  
  I tried to load aoColumns properties on the fnServerData call but i didnt get the titles painted.
  Something was wrong.
  Then i googled and saw this code, checked and worked. And all works fine now.
  
  I dont know why do this is so hard, i think it is a simple, very used example. U need to show datatable with some diferent configurations, depending from some parameters, like for example, the aplications user, depending of his rights.
  
  So on the first Ajax call, u send the aoColumns properties to show it rightly. And after u just have to send the filtered, paginated, ordered ... data.
  
  I am surprised i still dont know do this.
  
  http://datatables.net/forums/discussion/10455/changing-the-column-settings-dynamically-in-code/p1
  
  [quote]allan said: it is just not a supported option to change configuration properties on-the-fly like this.[/quote]
  [quote]allan said: you'd need to go through the DataTables source and see what the internal calls you would need to make (fnAdjustColumnSizing is a good place to start!).[/quote]
  
  i was checking datatables source since 2 days ago and i am lost, i dont get the solution for my problem.