Answers

• ignignokt Posts: 146Questions: 4Answers: 39

  February 2015 edited February 2015

  Try what I have below. I've never tried including data that was true or false, but I think it will show up as a string in the table.

  JS:

  $('#dataTable').DataTable({
      ajax: "todo/ajax",
      dataType: "json",
      columns:[
          {sTitle:"ID",data:"id"},
          {sTitle:"Done",data:"done"},
          {sTitle:"Action",data:"action"},
          {sTitle:"Priority",data:"priority"},
          {sTitle:"Due Date",data:"dueDate"}
      ]
  });
  

  HTML:

  <table id="dataTable" class="display" cellspacing="0" width="100%"></table>
  
• allan Posts: 63,364Questions: 1Answers: 10,449 Site admin

  February 2015

  You need to use ajax.dataSrc and set it to be an empty string if you are just returning an array.

  Allan
• Alex1990 Posts: 3Questions: 1Answers: 0

  February 2015

  Very thanks for your answers, its helps me for my application.
  I wrote this cod and it work now:

  $('#dataTable').dataTable( {
      ajax: "todo/ajax",
      dataType: "json",
      "sAjaxDataProp": "",
      columns:[
          {sTitle:"ID",data:"id"},
          {sTitle:"Done",data:"done"},
          {sTitle:"Action",data:"action"},
          {sTitle:"Priority",data:"priority"},
          {sTitle:"Due Date",data:"dueDate"}
      ]
  } );
  

  But i don't understand, why I should use property:

  "sAjaxDataProp": ""

  And property:

  "dataSrc": "" doesn't work

  This cod don't work:

  $('#dataTable').dataTable( {
      "dataSrc": "",
      ajax: "todo/ajax",
  
      columns:[
          {sTitle:"ID",data:"id"},
          {sTitle:"Done",data:"done"},
          {sTitle:"Action",data:"action"},
          {sTitle:"Priority",data:"priority"},
          {sTitle:"Due Date",data:"dueDate"}
      ]
  
  } );
  

  It has error: Uncaught TypeError: "Cannot read property 'length' of undefined". In datatables.js in string:

  // Got the data - add it to the table
  for ( i=0 ; i<aData.length ; i++ ) {

  aData is undefine
• allan Posts: 63,364Questions: 1Answers: 10,449 Site admin

  February 2015 Answer ✓

  If you have a look at the documentation for ajax.dataSrc you will see it is a property of ajax - not a top level property. So you would use:

  ajax: {
    url: 'todo/ajax',
    dataSrc: ''
  }
  

  The examples towards the bottom of the documentation page show a number of examples like this.

  Allan
• Alex1990 Posts: 3Questions: 1Answers: 0

  February 2015

  Thanks :)