Answers

• venlentine Posts: 2Questions: 1Answers: 0

  June 2014

  I find solution!

  Custom function to ajax.data

  eg:

   "ajax": {
                  "url": '${ctx}/work/list_ajax.json',
                  "type": 'POST',
                  "data": buildSearchData
              }
  
• allan Posts: 63,368Questions: 1Answers: 10,449 Site admin

  June 2014

  Yup - bob on :-). Thanks for posting your solution.

  Allan
• viandante Posts: 22Questions: 10Answers: 1

  September 2014 edited September 2014

  But with this solution... the default parameters, draw, search etc... are not sent...

  I search another solution...
• allan Posts: 63,368Questions: 1Answers: 10,449 Site admin

  September 2014

  But with this solution... the default parameters, draw, search etc... are not sent...

  As long as you have serverSide enabled, then yes they should be. If they are not, please link to a test case showing the problem.

  Allan
• geniuscd Posts: 2Questions: 0Answers: 0

  October 2014 edited October 2014

  I can confirm the issue. im using v1.9.3

  using this code

  table.dataTable({
      "processing": true,
          "serverSide": true,        
          "ajax": {
              "url" : "transactions.php",
           "type": "POST",
           "data" : { 
              "cmd" : "refresh",
              "from": $("#from-date")+" "+$("#from-time").val(),
              "to"  : $("#to-date").val()+" "+$("#to-time").val()
          }
  });
  

  when reloading, the "to" and "from" stays the same, even if I change the UI input, so the workaround from valentine works, but now the default params arent sent.

  "data" with buildSearchData function

  function buildSearchData(){
   var obj = {
       "cmd" : "refresh",
              "from": $("#from-date")+" "+$("#from-time").val(),
              "to"  : $("#to-date").val()+" "+$("#to-time").val()
  };
  return obj;
  }
  

  I was thinking of re-typing the defaults params in the function manually.
  but how can i get them?
• geniuscd Posts: 2Questions: 0Answers: 0

  October 2014 edited October 2014

  Ok so here is the work around, hope it helps someone

  function buildAjaxData (){
          var settings = $("#transactions").dataTable().fnSettings();
          console.log(settings);
          
          var obj = { 
              //default params
              "draw" : settings.iDraw,
              "start" : settings._iDisplayStart,
              "length" : settings._iDisplayLength,
              "columns" : "",
              "order": "",
              
              "cmd" : "refresh",
              "from": $("#from-date").val()+" "+$("#from-time").val(),
              "to"  : $("#to-date").val()+" "+$("#to-time").val()
              };
              
              //building the columns
              var col = new Array(); // array
              
              for(var index in settings.aoColumns){
                  var data = settings.aoColumns[index];
                  col.push(data.sName);
                                  
              }
              
              var ord = {
                  "column" : settings.aLastSort[0].col,
                  "dir" : settings.aLastSort[0].dir
              };
              
              //assigning
              obj.columns = col;
              obj.order = ord;
              
          return obj;
          
          
      }
  
• Pleyer Posts: 3Questions: 0Answers: 2

  November 2014 edited November 2014 Answer ✓

      "ajax": {
          "url": 'vendas_filter.php',
          "type": 'POST',
          "data": $('#formFilter').serializeArray()
      }
  

  But not working, cant "refresh" the data....
• Pleyer Posts: 3Questions: 0Answers: 2

  November 2014

  i can do that setting a new ajaxurl (via get) but i cant via post..

  var tableAjax = $('#table_vendas').DataTable();

  tableAjax.ajax.url('vendas_filter.php?'+$('#formFilter').serialize()).load();
• Pleyer Posts: 3Questions: 0Answers: 2

  November 2014 Answer ✓

  Ok.

  I solved that way:

  "ajax": {
  "url": 'filter.php',
  "type": 'POST',
  "data": function ( d ) {
  return $('#formFilter').serialize();
  }
  },