jquery - Disable initial automatic ajax call - DataTable server side paging -


i have datatable initialized server side paging , working fine. table triggers ajax, pulls data , renders onto table during initialization. need empty table , load table data on click of button using load() or reload() like:

mytable.api().ajax.reload();

here table initialization:

function inittesttable(){     mytable =  $('#testtable').datatable({     "processing": true,     "serverside": true,     "ajax": {         "url": "testtabledata.html",         "type": "get",     },     "columns": [         { "data": "code" },         { "data": "description" }     ]  }); }

there should way restrict loading of table during initialization? read documentation not find. please suggest.

you use deferloading parameter , set 0. delay loading of data until filter, sorting action or draw/reload ajax happens programmatically.

function inittesttable(){     mytable =  $('#testtable').datatable({     "processing": true,     "serverside": true,     "deferloading": 0, // here     "ajax": {         "url": "testtabledata.html",         "type": "get",     },     "columns": [         { "data": "code" },         { "data": "description" }     ]  }); }

to trigger ajax when button clicked can have following in handler:

function buttonclickhandler(event){   $('#testtable').datatable().draw(); }

see example below demonstration.

$(document).ready(function() {    // ajax emulation demonstration    $.mockjax({        url: '/test/0',        responsetime: 200,        response: function(settings){           this.responsetext = {              draw: settings.data.draw,              data: [                [ "tiger nixon", "system architect", "edinburgh", 61, "2011/04/25", "$320,800" ],                [ "tiger nixon", "system architect", "edinburgh", 61, "2011/04/25", "$320,800" ],                [ "tiger nixon", "system architect", "edinburgh", 61, "2011/04/25", "$320,800" ],                [ "tiger nixon", "system architect", "edinburgh", 61, "2011/04/25", "$320,800" ],                [ "tiger nixon", "system architect", "edinburgh", 61, "2011/04/25", "$320,800" ],                [ "tiger nixon", "system architect", "edinburgh", 61, "2011/04/25", "$320,800" ],                [ "tiger nixon", "system architect", "edinburgh", 61, "2011/04/25", "$320,800" ],                [ "tiger nixon", "system architect", "edinburgh", 61, "2011/04/25", "$320,800" ],                [ "tiger nixon", "system architect", "edinburgh", 61, "2011/04/25", "$320,800" ],                [ "tiger nixon", "system architect", "edinburgh", 61, "2011/04/25", "$320,800" ]              ],              recordstotal: 1000,              recordsfiltered: 1000           };        }    });      $('#example').datatable({          "processing": true,      "serverside": true,      "deferloading": 0,      "ajax": {          "url": "/test/0",          "type": "get"      }        });            $('#btn-reload').on('click', function(){       $('#example').datatable().draw()      });  });
<!doctype html>  <html>    <head>  <meta charset="iso-8859-1">  <link href="//cdn.datatables.net/1.10.5/css/jquery.datatables.min.css" rel="stylesheet"/>   <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script>   <script src="//cdn.datatables.net/1.10.5/js/jquery.datatables.min.js"></script>  <script src="http://vitalets.github.com/x-editable/assets/mockjax/jquery.mockjax.js"></script>      </head>  <body>  <p>  <button id="btn-reload">reload</button>  </p>  <table id="example" class="display" cellspacing="0" width="100%">    <thead>     <tr>        <th>name</th>        <th>position</th>        <th>office</th>        <th>age</th>        <th>start date</th>        <th>salary</th>     </tr>  </thead>    <tfoot>     <tr>        <th>name</th>        <th>position</th>        <th>office</th>        <th>age</th>        <th>start date</th>        <th>salary</th>     </tr>  </tfoot>    <tbody>  </tbody>  </table>  </body>  </html>


-

Comments

Post a Comment

Popular posts from this blog

OpenCV OpenCL: Convert Mat to Bitmap in JNI Layer for Android -

there several posts converting mat bitmap using utils.mattobitmap() function. i'm assuming function can called in java layer after importing utils class. i want transfer data memory address pointed uint32_t* bmpcontent; in code below. jniexport void jnicall java_com_nod_nodcv_nodcvactivity_runfilter( jnienv *env, jclass clazz, jobject outbmp, jbytearray indata, jint width, jint height, jint choice, jint filter) { int outsz = width*height; int insz = outsz + outsz/2; androidbitmapinfo bmpinfo; if (androidbitmap_getinfo(env, outbmp, &bmpinfo) < 0) { throwjavaexception(env,"gaussianblur","error retrieving bitmap meta data"); return; } if (bmpinfo.format != android_bitmap_format_rgba_8888) { throwjavaexception(env,"gaussianblur","expecting rgba_8888 format"); return; } uint32_t* bmpcontent; if (androidbitmap_lockpixels(env, outbmp,(void**)&bmpcontent)...
Read more

android - org.xmlpull.v1.XmlPullParserException: expected: START_TAG {http://schemas.xmlsoap.org/soap/envelope/}Envelope -

i trying hit soap api in application login purpose , getting above mentioned error , can 1 tell me going wrong , first time soap apis. here code hit soap :- vector<object> args = new vector<object>(); hashtable<string, object> hashtable = new hashtable<string, object>(); hashtable.put("email", "mss.siddhart28@gmail.com"); hashtable.put("password", "siddharth"); args.add(hashtable); soapserializationenvelope envelope = new soapserializationenvelope( soapenvelope.ver11); envelope.dotnet = true; envelope.xsd = soapserializationenvelope.xsd; envelope.enc = soapserializationenvelope.enc; (new marshalhashtable()).register(envelope); httptransportse androidhttptransport = new httptransportse( "http://tempuri.org/", 15000); androidhttptransport.debug = true; string result = ""; try { soapobject request = new soapobject("http:...
Read more

python - How to remove the Xframe Options header in django? -

i have made page has iframe . inside iframe want show multiple different links article facebook, or news, or youtube video or other possible url. but, due xframe header, unable so. referred following link: https://docs.djangoproject.com/en/1.8/ref/clickjacking/ , django xframeoptionsmiddleware (x-frame-options) - allow iframe client ip but didn't help. my settings.py file's middleware_classes is: middleware_classes = ( 'django.contrib.sessions.middleware.sessionmiddleware', 'django.middleware.common.commonmiddleware', 'django.middleware.csrf.csrfviewmiddleware', 'django.contrib.auth.middleware.authenticationmiddleware', 'django.contrib.auth.middleware.sessionauthenticationmiddleware', 'django.contrib.messages.middleware.messagemiddleware', 'django.middleware.clickjacking.xframeoptionsmiddleware', ) from http://django-secure.readthedocs.org/en/latest/middleware.html , found using ...
Read more