jhyland87 / datatables-live-ajax Goto Github PK

First off – awesome Javascript plugin; not sure why this hasn't gained more traction back in the days. Probably because less people use DataTables with Editor.

Anyways, is there a method to prevent the alert window from appearing when an error occurs and overwrite the functionality? I tried using the xhrErr.liveAjax, but couldn't manage to disable the default behavior.

Hi there!

I'm implementing a polling mechanism for my DataTables-based application and rather than writing everything from scratch, I stumbled across your plugin. I don't need the "selective updating" which is at the core of what you've done, but it's still low-hanging fruit to use DataTables LiveAjax for interval, pause, and cancel methods.

However, when I try to fire up liveAjax in a table, I encounter the following error:

Uncaught TypeError: Cannot read property '0' of undefined

Which is found on this line:

                if ( json[ dtSettings.liveAjax.dataSrc ][0][ dtSettings.liveAjax.rowId ] === undefined ){

I call my DT in a slightly unconventional way, but I'm not sure why it is failing:

fcapp.storedTables.sessionTable = $('#sessiontable').on('error.dt', fcapp.tables.dtErrorHandler).DataTable({
      "ajax": {
        "url": "/rs/sessions",
        "dataSrc": function (json) {
          return fcr.utils.ensureArray(json.session);
        },
        "headers": {
          "RESTSessionSecret": sessionStorage.getItem("currentSession")
        }
      },
      liveAjax: true,
      "columns": [
        {"data": "userName",
          "title": "user name"
        },
        {"data": "remoteIP",
          "title": "IP"},
        {
          "data": "fileName",
          "title": "file"
        },
        {
          "data": "status",
          "title": "status"
        },
        {"data": null,
          "sortable": false,
          "defaultContent": fcapp.render.tools('group'),
          "createdCell": function (td, cellData, rowData, row, col) {
            $(td).addClass('toolcell');
          }
        }
      ],
      "rowCallback": function (row, data, index) {
        fcapp.render.row(row, data, index);
      }
    });

DataTables is 1.10.8, and it is using dataTables.bootstrap.js as well.

Any insight? What are the usual causes of such an undefined?

hi i am using DataTables-Live-Ajax if i give serverSide:true, it making dual request to server, this scenario happens for specific interval, pls help to fix the issue

For another purpose, I just implemented a server-side mechanism to return a list of changes that have been made to a (table-like) data source since last request. It's fairly simple, one just has to keep a timestamp on server side to identify subsequent requests (keyed by for example custom HTTP request header, GET/POST parameter, or URL path segment).

It's easy to see that for large tables, it can be very effective to be able to parse and update the datatable from this 'diff' (instead of reloading the full data each time). Especially in a scenario when data is read often but updated realtively rarely, and one can keep a change journal on server side that's modified whenever data is changed (rather than a diff being computed for each request).

A table diff could be as simple as a JSON array containing records comprised of just a operation indicator and (added/deleted/changed) row contents. Operation indicators could be numbers, such as -1 for deletion, 0 for change and 1 for addition. Or symbols such as '+', '-' and '~' . I would not recommend using full verbs such as "add", "delete" & "change", although it does not of course matter that much if the set of changes is always fairly small between requests.