Answers

• allan Posts: 63,208Questions: 1Answers: 10,415 Site admin

  February 2018

  You'd use data.events since events is a nested object - however, DataTables expects an array of data - not an object of entries. You'd need to convert the object into an array. ajax.dataSrc can be used as a function if you wanted to do that on the client-side.

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

  February 2018 edited February 2018

  thank you for your reply,
  i researched around and this is what i come up with

  $('#example').DataTable({
    //'deferRender': false,
    'ajax'       : {
      "type"   : "POST",
      "url"    : "/test.txt",
      "dataSrc": function (json) {
        var return_data = new Array();
        for(var i=0;i< json.data.events.length; i++){
          return_data.push({
            'event': json.data.events[i],
            'date': json.data.events[i].date,
            'place': json.data.events[i].place,
            'participants': json.data.events[i].participants,
            'ideas': json.data.events[i].ideas,
            'detail': json.data.events[i].ideas[i].idea_detail[i],
            'last_update': json.data.events[i].ideas.last_update,
            'info': json.data.events[i].info
          })
        }
        return return_data;
      }
      
      },
      "columns"    : [
      {'data': 'event'},    
      {'data': 'date'},
      {'data': 'place'},
      {'data': 'participants'},
      {'data': 'ideas'},
      {'data': 'detail'},
      {'data': 'last_update'},
      {'data': 'info'}
    ] 
  }) 
  
  

  what could i be doing wrong?
  im not sure how i could construct the script properly
• aileenywdd Posts: 3Questions: 1Answers: 0

  February 2018

  $('#example').DataTable({
    //'deferRender': false,
    'ajax'       : {
      "type"   : "POST",
      "url"    : "/test.txt",
      "dataSrc": function (json) {
        var return_data = new Array();
        for(var i=0;i< json.data.events.length; i++){
          return_data.push({
            'event': json.data.events[i],
            'date': json.data.events[i].date,
            'place': json.data.events[i].place,
            'participants': json.data.events[i].participants,
            'ideas': json.data.events[i].ideas,
            'detail': json.data.events[i].ideas[i].idea_detail[i],
            'last_update': json.data.events[i].ideas.last_update,
            'info': json.data.events[i].info
          })
        }
        return return_data;
      }
      
      },
      "columns"    : [
      {'data': 'event'},    
      {'data': 'date'},
      {'data': 'place'},
      {'data': 'participants'},
      {'data': 'ideas'},
      {'data': 'detail'},
      {'data': 'last_update'},
      {'data': 'info'}
    ] 
  }) 
  

  i tried using the ajax.dataSrc base on what i could search online, but i believe im still lacking in knowledge with how to construct the scripts, could you help me?
• allan Posts: 63,208Questions: 1Answers: 10,415 Site admin

  February 2018

  json.data.events.length

  It has no length property. It is an object, not an array. You'd need to use for in or $.map or similar to convert it form being an object into an array.

  Allan