Answers

• colin Posts: 15,240Questions: 1Answers: 2,599

  May 2020

  That header is only needed when serverSide is enabled - if it's not, or if it's set to false then the header isn't required, only the second data that you pasted. What do you have in your initialisation?

  Colin
• trusta77 Posts: 4Questions: 2Answers: 0

  May 2020

  Previously my serverSide is true, but even after set it to false it's still show error

  jquery.dataTables.min.js:48 Uncaught TypeError: Cannot read property 'length' of undefined

  This is my istallation look like:

  var dt = $('#datatable').DataTable( {
          "order": [[ 0, "asc" ]],
          "lengthMenu": [50, 25, 10],
          "processing": false,
          "serverSide": false,
          "ajax": "ajax.php",
          "type":"post",
          "columns": [
          {
            "class":"details-control",
            "orderable":false,
            "data":null,
            "defaultContent": ""
          },
          { "data": "first_name" },
          { "data": "last_name" },
          { "data": "position" },
          { "data": "office" }
          ],
          "order": [[1, 'asc']]
        } );
  
• colin Posts: 15,240Questions: 1Answers: 2,599

  May 2020 Answer ✓

  Change:

  "ajax": "ajax.php"
  

  to be

  ajax: {
     url: 'ajax.php',
     dataSrc: ''
  }
  

  The data is at the top level of the returned object - the default would be 'data',

  Colin
• trusta77 Posts: 4Questions: 2Answers: 0

  May 2020

  Oh, it's working nicely.
  In my previous attempt, I use javascript to parse my ajax and then using row.add() to add data to the table in a loop, this one could actually save lots of time. Thankyou very muuch.