DataTables ajax.reload() not working

Question

I spend so much time and can not udnerstand why datatables can not refresh my table, i am getting already crazy with this datatables

my code is below, i spent weeks on it but is impossible to get it to work and i use ajax.reload

DataTablesDraw = (selector, order, pages, file, sort, column, template, data_set) ->
$(selector).DataTable
  'pageLength': pages
  'ordering': sort
  'destroy' : true,
  'paging': true
  'responsive': true
  'searching': false
  'info': false
  'lengthChange': true
  'autoWidth': false
  'select': true
  'dom': 'Bfrtip',

  'buttons': [
          {
            'extend': 'excelHtml5',
            'title': file + new Date()
          },
          'copyHtml5'
      ],
  'order': [ [ column, 'desc' ] ],
  'language': {
        buttons: {
            copyTitle: i18n[lang]['id[9]'],
            copySuccess: {
                _: i18n[lang]['id[10]'] + ' %d ' + i18n[lang]['id[11]'],
                1: i18n[lang]['id[12]']
            }
        }
    }
  'ajax': '/settings/ranges/ranges.txt',
  "dataSrc": "data",
  'drawCallback': (settings) ->

    $('.dataTables_paginate > span').remove()
    excel = $('#DataTables_Table_' + order + '_wrapper .buttons-excel').detach()
    copy = $('#DataTables_Table_' + order + '_wrapper .buttons-copy').detach()

    if not $('#DataTables_Table_' + order + '_wrapper thead.tfoot').length
      $(this).append '<thead class="tfoot">' +
            '<tr>' +
                '<th colspan="10">' +
                    '<div class="export">' +
                        '<div class="buttons"></div>' +
                    '</div>' +
                    '<div class="paginator"></div>' +
                '</th>' +
            '</tr>' +
         '</thead>'

    paginator = $('#DataTables_Table_' + order + '_paginate').detach()
    $('#DataTables_Table_' + order + '_wrapper thead .paginator').append paginator
    $('#DataTables_Table_' + order + '_wrapper thead .export .buttons').append excel, copy

    if @fnPagingInfo().iTotalPages <= 1
      $('#DataTables_Table_' + order + '_paginate').hide()
      $('#DataTables_Table_' + order + '_info').hide()
    else
      $('#DataTables_Table_' + order + '_paginate').show()
      $('#DataTables_Table_' + order + '_info').show()

    return

  'columns': template
return

calling

table= DataTablesDraw '.__ranges__', 0, 25, 'Current Ranges ', true, 5, CurrentRangesTemplate, ranges #selector, order, pages, file name, sorting
table.ajax.reload()

the table is getting the data from the file everything is fine, just ajax.reload() cant fix to work

data

{"data": [{"status": "1", "environment": "demo", "currency": "EUR", "range_to": 42342, "date_update": 1491814286, "server": "server", "date_create": 1491814286, "platform": "platform", "range_from": 432423, "user": {"email": "[email protected]"}]}

aaa · Accepted Answer · 2021-09-19 06:52:10Z

16

The mistake was that u used ajax reload in this format

table.ajax.reload()

but in order to fix the mistake i jsut needed to do in this way

$('#table').DataTable().ajax.reload()

Hope this will help other, spent so much time on it on this small thing

edited Sep 19, 2021 at 6:52

answered Apr 15, 2017 at 18:15

aaa

5442 gold badges9 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Akshay K Nair Over a year ago

But why? The docs (datatables.net/reference/api/ajax.reload()) says its possible to do using the variable.

Priya-Systematix · Accepted Answer · 2017-04-11 11:38:54Z

7

Please check your version of datatable Jquery for using ajax.reload(). If you are using older version like(1.10) then you have to use API of datatable.

$('#table_data').dataTable( ).api().ajax.reload();

It will be work for you.

or for reloading table, you can 1st destroy datatable and again load it.for eg.

 table = $("#table_data").datatable()
$("#my-button").click(function() {
    table.fnDestroy();
    table = $("#table_data").dataTable();
});

answered Apr 11, 2017 at 11:38

Priya-Systematix

1192 silver badges6 bronze badges

2 Comments

Kamlesh Over a year ago

getting error: Uncaught TypeError: dataTable.fnDestroy is not a function.

TheAlphaGhost Over a year ago

Use DataTable() instead datatable()

Collectives™ on Stack Overflow

DataTables ajax.reload() not working

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related