How to load extra Javascript in Datatable Server Side processing?

Question

I am using Datatable.net 1.10, with server processing. It is all good and working fine, but I can't get other javascript to work in the datatable. For example I was using tippy.js to generate nice tooltip in the table. This was working fine with client-side processing but javascript is totally ignored while using server-side processing.

Here is the Javascript I am using for the datatable (shortenened a bit):

function myDataTableAjax_Accident(id, actionURL) {

    var areaDDL = document.getElementById('_AreaDDl');
    var areaID = areaDDL.options[areaDDL.selectedIndex].value;

    var incidentStatusDDL = document.getElementById('_IncidentStatus');
    var incidentStatusID = incidentStatusDDL.options[incidentStatusDDL.selectedIndex].value;

    var incidentKind = document.getElementById('incidentKind').value;

    $('#' + id).DataTable({

        dom: //cut for shortness
        , serverSide: true
        , processing: true
        , pageLength: 100
        , deferRender: true
        , ajax: {
            url: actionURL,
            type: 'POST',
            contentType: "application/json",
            data: function (model) {           
                return JSON.stringify(model);
            },
        },
        columns: [

            { data: null, defaultContent: "" },
            { data: "incident_EHSconnect_ID" },
            {
             data: "accident_type_name", defaultContent: defaultValueTxt
            },

            { data: "incident_category", defaultContent: "" },
            { data: "incident_area_name", defaultContent: "" },
            { data: "location", defaultContent: defaultValueTxt },

            { data: "incident_description", defaultContent: "" },

            {
             data: null,
             defaultContent: "",
             orderable: false,
             render: function (data, type, row, meta) {
                 var btns =
                 '<button id="' + data.incident_ID + '" data-id="' + data.incident_ID + '" class="modalDetails btn btn-default btn-control col-md-6 tip" title="Shows details of the accident" ><span class="glyphicon glyphicon-modal-window "></span> Details</button>' +
                 '<a href="' + webroot + "/EHSConnect_Incident/EditIncident/?incidentID=" + data.incident_ID + '" title="Edit the accident details" class="tip btn btn-primary btn-control col-md-5" style="margin-left:5px;"><span class="glyphicon glyphicon-edit"></span> Edit   </a>' +
                 '<a href="' + webroot + '/EHSConnect_Dashboard/ExportToPdf/?incidentID=' + data.incident_ID + '" title="View in browser as PDF and download"  class="tip btn btn-info btn-control col-md-6"><span class="glyphicon glyphicon-download"></span> PDF</a>'
                 ;
                 if (!data.signed_by_injured_party) {
                     btns += '<a href="' + webroot + '/EHSConnect_Incident/SignAccident/?incidentID=' + data.incident_ID + '" title="Electronically sign accident" class="tip btn btn-warning btn-control col-md-5" style="color:black;margin-left:5px;"><span class="glyphicon glyphicon-pencil"></span> Sign</a>';
                 }

                 return btns;
             }
            },
        ],
        columnDefs: [{
            className: 'control',
            orderable: false,
            targets: 0
        }],
    });
}

And here is the view:

@using AspMvcUtils
@using EHS.Utils


<table  class="table table-bordered tblAccident" style="margin-top: 0px !important; width: 100%;" id="tblAccident">
    <thead class="scrollStyle">
        <tr>
            <th></th>
            <th>ID</th>
            <th>Type</th>
            <th>Category</th>
            <th>Location</th>
            <th>Exact Location</th>
            <th>Description</th>
            <th>Reported by</th>
            <th>Reported Date</th>@*6*@
            <th>Incident status</th>
            <th data-priority="-1" class="col-md-6" style="max-width:150px;">Controls</th>
        </tr>
    </thead>

    @*Rows -------------------------------------------------------------------------------------------------------*@

    <tbody class="scrollStyle">    </tbody>

</table>

<div id="modalContainer" class="col-lg-12 col-md-12 col-sm-12 col-xs-12"></div>

<script>
   tooltip('.tip', 'ehs');

       $(document).ready(function () {
        myDataTableAjax_Accident('tblAccident', '@Url.Action("DatatableServerSideIndex")');
    });
</script>

And here is the tooltip function:

function tooltip(selector, userTheme) {
tippy(selector, {
    theme: userTheme,
    position: 'right',
    animation: 'scale',
    duration: 600
})

}

(I am using ASP.NET MVC4 by the way).

How can I get the extra javascript to work properly in the table?

YouneL · Accepted Answer · 2017-11-07 11:48:25Z

1

You have to call tooltip after datatables complete its initialization, you can use fnInitComplete callback to do that:

$(document).ready( function() {

  $('#example').dataTable({

    ...,

    "fnInitComplete": function(oSettings, json) {
      alert( 'DataTables has finished its initialisation.' );
      // call tooltip here
      tooltip('.tip', 'ehs');
    }

  });

});

Because you are using datatables and tooltip in 2 separate functions you can use callbacks to call them in order:

myDataTableAjax_Accident function:

function myDataTableAjax_Accident(id, actionURL, done) {

    ...,

    "fnInitComplete": function(oSettings, json) {

        done();

    }

}

And then in your View you can pass done parameter as a function and then call tooltip like this:

<script>
    $(document).ready(function () {
        myDataTableAjax_Accident('tblAccident', '@Url.Action("DatatableServerSideIndex")', function() {
            tooltip('.tip', 'ehs');
        });
    });
</script>

edited Nov 7, 2017 at 11:48

answered Nov 7, 2017 at 11:11

YouneL

8,3692 gold badges30 silver badges52 bronze badges

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

5 Comments

Syl20 Over a year ago

Thanks for that! Working like a charm. Thanks for the link as well!

YouneL Over a year ago

Glad it helps, did you call the tooltip function inside myDataTableAjax_Accident function ?

Syl20 Over a year ago

Yep I did call it in the myDataTableAjax_Accident function, at the very end, after all the rendering etc...

YouneL Over a year ago

You can use callbacks to separate them both, i'm updating my answer

Syl20 Over a year ago

Nice ! Thanks for the callback example. I have upvoted your answer, but I don't have enough rep for it to be visible publicly apparently...

Collectives™ on Stack Overflow

How to load extra Javascript in Datatable Server Side processing?

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related