Answers

• latinunit Posts: 73Questions: 12Answers: 0

  March 2023

  Update

  I think I solevd it, by sending an error response from my API if the data length is 0 but the loading spinner (processing flag) stays spinning. how do I turn it off? in this scenario

  (p
• kthorngren Posts: 21,330Questions: 26Answers: 4,951

  March 2023 edited March 2023

  Since Datatalbes expects the ajax data to be in the data object by default and the row data to be in an array you should return this:

  {
    data: []
  }
  

  Kevin
• latinunit Posts: 73Questions: 12Answers: 0

  March 2023 edited March 2023

  Thanks K, that seems to have done the trick.
  

   ajax: {
                  url: urlEndpoint,
                  data: function (d) {
                  let session = sessionStorage.getItem("query")
                      d.cr = session ? $('#created').val() : new Date().getFullYear()+"-03-01";
                      d.rm = $('#rm').val();
                      d.st = $('#superTeam').val();
                      d.ss = $('#status').val();
                      d.it = $('#invType').val();
                      d.oj = operatorJurisdiction;
                  },            
                  type: 'POST',
                  headers: {},
                   error: function (request, status, error) {
                        alert(request.responseText);
                    }                          
                 },      
  

  where in the ajax can I check for data.length on ajax response so that I can pop up and alert?

  maybe something like the following

  success: function  (request, status, error) {
     if request data length is > 0 then 
      $("#result").html("Successful");
  },
  
• kthorngren Posts: 21,330Questions: 26Answers: 4,951

  March 2023 Answer ✓

  You can use the xhr event or the ajax.dataSrc option.

  Kevin
• latinunit Posts: 73Questions: 12Answers: 0

  March 2023

  Thanks Kevin,

  I found the solution with your suggestion

      table.on( 'xhr', function () {
      var json = table.ajax.json();
        if(json.data.length == 0) {
          alert('No data found');
        }
      });