Search

I'm managing to play with a backend service called Baasbox, it has javascript api subset that allow me to query the database via dedicated function and I'm interested to populate a table with datatables using this. It would act like ajax, but I can't figure out if this is possibile with DT. I'm trying to have something like: 1st page render the page call fox BB.loadCollection('db', function(res, err){ // use res to populate the table }); and retrieve totalitems + n°of pages On click on page + I call again the BB.loadCollection querying for page 2, etc.

I'm currently populating my datatable via a server-side php script from a mysql database. I'd like to make certain column data a hyperlink to another page within my site. I've seen examples in other forums with the following syntax but this isn't working for me. $('#example').dataTable({ "bProcessing": true, "bServerSide": true, "sAjaxSource": "archive/archive.txt" "fnRowCallback": function( nRow, aData, iDisplayIndex ) { $('td:eq(2)', nRow).html('' + aData[2] + ''); return nRow; }, I don't see any javascript errors with this format but the hrefs never get added almost like fnRowCallback never kicks in. Any help would be much appreciated.

Hi my code is like this,first ajax call is working fine ,if i enter the new value in search box and pressing the enter then it is making two ajax calls first with old search value and then new search value.i want to make only one ajax call with new search value, please help on this. var oTable =$("#deviceListTable").dataTable({ "bPaginate": true, "sPaginationType" : "full_numbers", "bLengthChange": false, "bFilter": true, "bSort": true, "bInfo": true, "bAutoWidth": false, "sScrollY": "150px", "bScrollCollapse": false, "bJQueryUI": true, "bProcessing": true, "bServerSide": true, //"sSearch" : isearch, "sAjaxSource": "./ajaxDevicelist.htm?&fromDate="+fromDate+"&toDate="+toDate+"&IsExport=false&mySearch="+isearch, "sDom": 'T<"clear">lfrtip', "oTableTools": { "aButtons": [ { "sExtends": "text", "sButtonText": "Export to Excel", "fnClick": function ( nButton, oConfig, oFlash ) { window.location.href="./ajaxDevicelist.htm?&fromDate="+fromDate+"&toDate="+toDate+"&IsExport=true"; } }, { "sExtends": "text", "sButtonText": "Download Configs", "fnClick": function ( nButton, oConfig, oFlash ) { dialogval.dialog( "open" ); } } ] }, "aoColumnDefs":[/*{ "aTargets": [5], "fnRender": function (o,val) { return "<a href='#' onclick=getid('"+ val +"')><center><img src='images/export.png' name='but' title='click here to download/view all configuration data' alt='download' ></center></a>"; } },*/ { "aTargets": [5], "fnRender": function (o,val) { return "<center><input type='checkbox' id='deviceid' name='devicename' value='"+val+"' /></center>"; } }, { "bSortable": false, "aTargets": [ 5 ] } ] }); $("div.dataTables_filter input").keyup( function (e) { if (e.keyCode == 13) { oTable.fnClearTable(this); isearch= $('#deviceListTable_filter label input:text').val(); console.log("isearch value is :"+isearch); var oSettings = oTable.fnSettings(); oSettings.sAjaxSource = "./ajaxDevicelist.htm?&fromDate="+fromDate+"&toDate="+toDate+"&IsExport=false&mySearch="+isearch; console.log("isearch value is :"+isearch); oTable.fnDraw(); } } );

Hi, When I use sUrl for oLanguage and try to append text to table_filter, the text does not appear. When I use other options of oLanguage (e.g.: sProcessing), the text appears just fine. [code] th td var audit = $("#table").dataTable({ "oLanguage": { // "sUrl": "js/dataTables.english.txt" // Uncomment this for text below to appear } }); // Add text near filter // Text does not appear when sUrl of oLanguage is used $("#table_filter").after("THIS TEXT SHOULD APPEAR NEAR THE FILTER"); </script> [/code] Please help! TIA, Dror

in the download builder URL. Allan

options={{ destroy: true, language: { url: '/dataTableLanguaje.json', }, }} > <thead> <tr>

I referenced the following URL https://datatables.net/manual/react

on the nightly file's URL to act as anti-cache.

global: false, cache: false, url: '/Dashboard/Administration/Users/FetchUsers', type: 'POST', datatype:

parameter is this: ajax: { url: '/media/blog/2016-03-25/users.php', type: 'post', data: