Replies

• Stephan Posts: 20Questions: 0Answers: 0

  July 2011 edited July 2011

  I am not sure what you mean by saying
  [quote]jay.chandran said: When a search is matched, I am calling fnReloadAjax on the datatable as below.[/quote]
  Do you have something like a search and on submit you want to filter the table depending on this form.input.values?
  In this case you could introduce javascript variables for ech search_input. on form.submit set them to the corresponding input values.
  Add this variables to fnServerData.
  In the "else"-tree of your code simply call comListTable.fnDraw() - a xhr request is fired, fnServerdata adds the extra information of the search.
  But use this only for custom search functionality, not for column filtering.
  
  [code]
  //your form should set this value on submit!
  var searchValue1 = "initialTestValue";
  
  oTable = $('#tableDiv').dataTable( {
  "bServerSide": true,
  "bProcessing": true,
  "sAjaxSource": yourServerSideScript.php",
  "fnServerData": function ( sSource, aoData, fnCallback ) {
  aoData.push({"name": "parameterNameForServerSideProcessing", "value": searchValue1});
  $.getJSON( sSource, aoData, function (json){
  fnCallback(json)
  });
  }
  
  [/code]
  
  What do you want to do here?
  [quote]jay.chandran said: oSettings.sAjaxSource = url;[/quote]
  May be i got you all wrong and you want to alter your ajaxsource depending on inputs?
• jay.chandran Posts: 10Questions: 0Answers: 0

  July 2011

  Hi Stephan,
  
  Yes, I am using Search form and on submit, I want to filter the datatable. So if I use [code] .fnDraw() [/code], along with [code] fnServerData [/code] will datatable send all the proper required datatable parameters?
  
  [code] oSettings.sAjaxSource = url; [/code] is the server side script.
  
  I will test and let you know.
• fbas Posts: 1,094Questions: 4Answers: 0

  July 2011

  The best way to add parameters to a call to the database script is by overriding fnServerData, and adding objects (with name and value) to the aoData collection:
  
  [code]
  "fnServerData": function ( sSource, aoData, fnCallback ) {
  /* Add some extra data to the sender */
  aoData.push( {"name": "daterecv_start", "value": $('#daterecv_start').val() } ); // <-- this
  aoData.push( {"name": "daterecv_end", "value": $('#daterecv_end').val() } ); // <-- this
  
  $.getJSON( sSource, aoData, function (json) {
  /* Do whatever additional processing you want on the callback, then tell DataTables */
  fnCallback(json)
  } );
  },
  [/code]
  
  fnDraw, when you have bServerSide set to true, will initiate fnServerData. Every call to the server will add your custom parameters to the set.
• jay.chandran Posts: 10Questions: 0Answers: 0

  July 2011

  Thanks Stephan & fbas for your inputs. It works fine. :) :) Thanks a lot. :)