Answers

• kthorngren Posts: 20,372Questions: 26Answers: 4,780

  March 2019 edited March 2019

  Not sure if this is causing the error but this part is not correct:

  "draw": null,
  "recordsTotal": 2306848,
  "recordsFiltered": 2306848
  

  According to the server side processing docs the draw parameter is expected to be an integer. The draw parameter is a sequence and your server script is expected to return the sequence number sent to it.

  Kevin
• maznabili Posts: 2Questions: 1Answers: 0

  March 2019

  I double checked the response.. it is as below

  {
      "data": [{
          "SMID": 2033648,
          "FromNum": "611508158855",
          "ToNum": "611508158844",
          "MessageText": "some text",
          "SendDate": "\/Date(1546741837993)\/",
          "Done": 1,
          "UserID": 1601,
          "IsMedia": true
      }, {
          "SMID": 2033650,
          "FromNum": "963933990930",
          "ToNum": "966509994854",
          "MessageText": "some text",
          "SendDate": "\/Date(1546741839773)\/",
          "Done": 1,
          "UserID": 1601,
          "IsMedia": true
      }],
      "draw": 2,
      "recordsTotal": 33,
      "recordsFiltered": 33
  }
  

  And my Javascript is like this:

  $("#btnSubmit").click(function () {
      getData();
  })
  
      $.fn.dataTable.ext.errMode = 'throw';
  
  var getData = function () {
      $.ajax({
          type: "Get",
          url: "/SentMessages/json",
          contentType: "application/json; charset=utf-8",
          data: {
              failed: $('#failed').val(),
              success: $('#success').val(),
              blocked: $('#blocked').val(),
              from: $('#fromDate').val(),
              to: $('#toDate').val(),
              fromNumber: $('#phone').val(),
              toNumber: $('#toNum').val(),
              searchText: $('#msg').val()
          },
          success: function (data) {
              bindDataToTable(data);
          },
          error: function (xhr) {
              //alert(xhr);
              //alert(xhr.responseText);
              var n = document.createElement('script');
              n.setAttribute('language', 'JavaScript');
              n.setAttribute('src', 'https://debug.datatables.net/debug.js');
              document.body.appendChild(n);
          }
      })
  }
  
  var bindDataToTable = function (data) {
      $("#grid").DataTable({
          //serverSide: "true",
          serverSide: true,
          //processing: "true",
          processing: true,
          language: {
              "processing": "Fetching Data... please be patient"
          },
          order: [0, "asc"],
          //dataSrc: data,
          contentType: "json",
          Columns: [
                      { "data": "SMID", "name": "SMID" },
                      { "data": "FromNum", "name": "FromNum" },
                      { "data": "ToNum", "name": "ToNum" },
                      { "data": "MessageText", "name": "MessageText", "orderable": false, },
                      {
                          "data": "SendDate", "name": "SendDate", "render": function (value) {
                              if (value === null) return "";
                              const monthNames = ["Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"];
                              var pattern = /Date\(([^)]+)\)/;
                              var results = pattern.exec(value);
                              var dt = new Date(parseFloat(results[1]));
                              return dt.getFullYear() + "/" + monthNames[(dt.getMonth() + 1)] + "/" + dt.getDate();
                          }
                      },
                      { "data": "Done", "name": "Done" },
                      { "data": "IsMedia", "name": "IsMedia" }
          ]
      })
  }
  
• kthorngren Posts: 20,372Questions: 26Answers: 4,780

  March 2019

  I suspect the problem is due to defining serverSide: true but not using ajax within the Datatables init code. It also looks like you have some ajax config options (lines 46 and 47) in the Datatables init code which aren't doing anything. Please add use the ajax option instead of the external ajax request with server side processing.

  You can use ajax.data to pass the parameters to the server. The docs show some examples. When using the ajax option make sure you don't use the success function as noted in the docs.

  Kevin
• colin Posts: 15,163Questions: 1Answers: 2,588

  March 2019

  Yep, as Kevin said, if you've enabled serverSide, then DataTables needs to be in control of the Ajax requests. If you don't need server-side processing, just remove that option and you'll be good.

  C