Answers

• allan Posts: 63,498Questions: 1Answers: 10,470 Site admin

  September 2023

  If you don't have any data to load you need to return an empty data array.

  Perhaps you can link to your page so I can offer some more help (i.e. I need to be able to see the specifics of the returned data and configuration of the table).

  Allan
• rodolphen Posts: 18Questions: 4Answers: 0

  September 2023

  Hi,
  I can't it is on intranet only.
  I have the same code&page as datable 1.10.9 but I have this :

  Else here an extract of JS, as I set data to null in $(document).ready(function() :

  var table = $('#tablereporting').DataTable( {

      "sScrollX": "100%",
      "bScrollCollapse": true,
      "order": [ 5, "asc" ],
      "deferRender": true,
      "columnDefs": [ 
          {
              "targets": 0,
              "className":      'details-control',
              "orderable":      false,
              "data":           null,
              "defaultContent": '',
              "sWidth": "20px"
  
          },
  

  
• kthorngren Posts: 21,327Questions: 26Answers: 4,949

  September 2023

  I would first look at the browser's console for errors. Use the browser's network inspector tool to view the JSON response. You can post it here. Use Markdown to format the code output. As Allan suggested the data object should be an empty array, ie data: [], if no rows are returned.

  Kevin
• rodolphen Posts: 18Questions: 4Answers: 0

  September 2023

  Hi,
  There is no error in console.
  I am on server side with ajax. Data should be an empty array, until a request is sent.
  It works good with datatable 1.10.9
  As I have no data, no row, I don't want to have the processing message.
  thank you,
• kthorngren Posts: 21,327Questions: 26Answers: 4,949

  September 2023

  We understand the problem description but need more information to help debug. Can you post the JSON response that is causing the issue? If not maybe use the debugger to gather diagnostic info for Allan to review.

  Kevin
• rodolphen Posts: 18Questions: 4Answers: 0

  September 2023

  Hummm, it seems the ajax is called anyway, but it is empty :

  the configuration :
  "processing": true,
  "serverSide": true,
  "ajax": "ajax/search_DB_reporting_h.php",
  "drawCallback": function( settings ) {
  cursor_defaut();
  },

  And result of ajax :
  {"draw":0,"recordsTotal":0,"recordsFiltered":0,"data":[]}
• kthorngren Posts: 21,327Questions: 26Answers: 4,949

  September 2023

  Yes, when Datatables initializes it will send an Ajax request for the data. The problem is with the response. It has "draw":0 which is incorrect. The draw parameter is a sequence number and Datatables always starts with 1 so a response with draw=0 should never happen. See the Server Side Processing Protocol docs for details.

  I don't know where it was changed but I believe there was a bug fix where Datatables accepted "draw":0 when it shouldn't.

  My guess is the server script is checking for draw=1 being sent in the request and will return the above response if so. Change it to return draw=1 and it should work correctly.

  Kevin
• rodolphen Posts: 18Questions: 4Answers: 0

  September 2023

  Hi,
  It works better, thank you!