Jquery DataTable - function to process before ajax and disable ajax for a condition

Question

I'm using Jquery DataTable 1.10.15 and here's my data table. I want to check when a user click on each page that page's record reached an amount and if it does I want to pop up saying narrow down your search instead of displaying the page they want which means no ajax call/table load. The below code worked on the alert but when I return false I thought it will not do the ajax call but it still does. Anyone know how to do it?

var myTable = $('#myTable')
.on('preXhr.dt', function ( e, settings, data ) {
    if (data.start + data.length >=10000) {
        alert('here');
        return false;
    }
})
.DataTable({
    searching: true,
    processing: false,
    serverSide: true,     
    columns: columnsList,
    pageLength: 25,
    ajax: {

All you need to do is modiy your .on('preXhr.dt'..) and add a callback — kblau
– kblau, Commented May 3, 2017 at 23:01
Your can do other things like data.draw(false), but this will not be cross browser compliant and is wrong. — kblau
– kblau, Commented May 4, 2017 at 16:05

kblau · Accepted Answer · 2017-05-03 19:22:51Z

1

This is how you do this:

$(document).ready(function () {
        //added this variable
        var stopAjaxing = false;
        $('#example').on('preXhr.dt', function (e, settings, data) {
            //changing to 100 since it works for rows, not pagges
            if (data.start + data.length >= 100) {
                //return false;
                //moved message to callback
                stopAjaxing = true;
            }
        })
        .dataTable({
            "preDrawCallback": function (settings) {
                if (stopAjaxing) {
                    alert("You need to refine  your search");
                    return false;
                }
                else {
                    return true;
                }
            },  
...

answered May 3, 2017 at 19:22

kblau

2,1221 gold badge12 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

Jquery DataTable - function to process before ajax and disable ajax for a condition

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related