Answers

• lsl031 Posts: 7Questions: 1Answers: 0

  August 2017

  HTML CODE:

  firstName	lastName
• lsl031 Posts: 7Questions: 1Answers: 0

  August 2017

  </table class="table table-striped table-bordered table-hover" id="db_conf">
  </thead>
  </tr>
  </th>firstName</th>
  </th>lastName</th>
  </tr>
  </thead>
  </table>
• lsl031 Posts: 7Questions: 1Answers: 0

  August 2017

  var oTable = null;
  var initUserList = function () {
  var table = $('#db_conf');
  if (oTable == null) {
  oTable = table.dataTable({
  "bProcessing": true,
  "bServerSide": true,
  "sAjaxSource": "/db_info_ajax/",
  "fnServerData": retrieveData,
  "fnServerParams": function (aoData) {
  aoData.push(
  { "name":"db_name","value": $('#form-field-select-1').val()} ) },
  "columns": [
  { "emplyees": "firstName" },
  { "emplyees": "lastName" } ],
  });
  }
  oTable.fnDraw();
  console.log('fnDraw');
  }

  function retrieveData(sSource, aoData, fnCallback) {
  $.ajax({
  "type": "post",
  "url": sSource,
  "dataType": "json",
  "data": aoData,
  "success": function(resp) {
  fnCallback(resp);
  } });
  }

  jQuery(document).ready(function ()
  { initUserList();
  $(".a_post").click(function () {
  alert('dsadda');
  initUserList() ; })

  });
• kthorngren Posts: 21,322Questions: 26Answers: 4,948

  August 2017 Answer ✓

  Where I would start is to change your columns to match the structure defined in columns.data:

  Change "employees" to "data":

  "columns": [
  { "data": "firstName" },
  { "data": "lastName" } ],
  });
  

  Then change your dictionary to match:

  conf={
  "data": [
  { "firstName":"Bill" , "lastName":"Gates" },
  { "firstName":"George" , "lastName":"Bush" },
  { "firstName":"Thomas" , "lastName":"Carter" }
  ]
  }
  

  See if that gets you further.

  Kevin
• lsl031 Posts: 7Questions: 1Answers: 0

  August 2017

  it works!thanks very much!
• lsl031 Posts: 7Questions: 1Answers: 0

  August 2017

  but if i want get two json dict data from python to update two diffrent tables ,how can i specify the columns.data？thanks！
• kthorngren Posts: 21,322Questions: 26Answers: 4,948

  August 2017 Answer ✓

  two diffrent tables ,how can i specify the columns.data?

  Datatables, by default, expects the data to be returned in a data object. When defining in Datatables you will always use the word data and define the appropriate columns for each table.

  Kevin
• lsl031 Posts: 7Questions: 1Answers: 0

  August 2017

  Thanks,Kevin。