Answers

• tangerine Posts: 3,365Questions: 39Answers: 395

  November 2014

  http://datatables.net/examples/data_sources/ajax.html
• anjibman Posts: 115Questions: 10Answers: 0

  November 2014 edited November 2014

  Hope following code snippet help to understand my question.

  $(document).ready(function () {
    myTable = $('#myTable').dataTable({
      //I don't have AJAX call here just table configuration
    });
  });
  

  someMethod() {
    $.ajax({
      //I make AJAX call here to get data
      success: function(response) {
        //I have to load this response (which is JSON string) in myTable
      }
    });
  }
  
• allan Posts: 63,498Questions: 1Answers: 10,471 Site admin

  November 2014

  Use rows.add() to add new data to the table.

  Allan
• anjibman Posts: 115Questions: 10Answers: 0

  November 2014

  I am using v1.10.2 but I am getting

  myTable.rows is undefined
  
• allan Posts: 63,498Questions: 1Answers: 10,471 Site admin

  November 2014 Answer ✓

  Second top FAQ:

  Q. I get an error message stating that an API method is not available
  A. Very likely you are using a jQuery object rather than a DataTables API instance. The form $().dataTable() will return a jQuery object, while $().DataTable() returns a DataTables API instance. Please see the API documentation for further information.

  Allan
• anjibman Posts: 115Questions: 10Answers: 0

  November 2014

  I am able to load the content but I have another question here. My 5th columns is an address so it should combine different field from the JSON string (e.g. addressLine1, addressLine2, city, state, and zipcode). How can I load and format the column so it have following format

  123 Main  St
  Apt#20
  Farmville, NV 88901
  

  My code look like this

  $('#btnSearchMember').click(function() {
          if(validMemberSearchForm()) {
              $jq11.ajax({
                  type: 'POST',
                  url: '/telephone/memberSearch.htm',
                  data: $("#memberSearchForm").serialize(),
                  cache: false,
                  success: function(response) {
                      var resultTable = $jq11('#memberSearchResultTable').DataTable({
                          "aoColumnDefs": [{
                              "bSortable": false, 
                              "aTargets": [4]
                          }],
                          "columns": [
                              { data: 'memberPrefId' },
                              { data: 'firstName' },
                              { data: 'lastName' },
                              { data: 'groupName' },
                              { data: 'addressLine1' },
                              { data: 'status' }                          
                          ],
                          "destroy": true,
                          "dom": 'lrtip',
                          "language": {
                              "emptyTable": "No match member found",
                              "infoFiltered": " "
                          },
                          "order": [[2, "desc"]]
                      });
                      resultTable.rows.add(response).draw();
                      dataSet = response;
                      displayMemberSearchResult();
                  }
              });
          }
      });
  
• allan Posts: 63,498Questions: 1Answers: 10,471 Site admin

  November 2014 Answer ✓

  Use columns.render.

  Allan
• tangerine Posts: 3,365Questions: 39Answers: 395

  November 2014 Answer ✓

  Write yourself a "render" function.

  https://datatables.net/reference/option/columns.render