Search

the Editor however, Editor creates a duplicate row (with

I just want to destroy and reinitialize datatable. I initialized datatable with following options dataTableobj = $("#dataTable").dataTable({ "bDestroy": true, "scrollX": true, dom: 'Bfrtip', buttons: ['csv', 'excel', 'pdf'] }); but trying to destroy it with following line dataTableobj.fnDestroy(); it returns following error in console TypeError: a[b] is undefined with following inner details .destroy() dataTables.buttons.min.js:7 ._constructor/<() dataTables.buttons.min.js:10 m.event.dispatch() jquery.min.js:3 m.event.add/r.handle() jquery.min.js:3 m.event.trigger() jquery.min.js:3 .trigger/<() jquery.min.js:3 .each() jquery.min.js:2 m.prototype.each() jquery.min.js:2 .trigger() jquery.min.js:3 u() jquery.dataTables.min.js:75 <anonymous> jquery.dataTables.min.js:137 .iterator() jquery.dataTables.min.js:99 <anonymous> jquery.dataTables.min.js:136 r.extend/g/<() jquery.dataTables.min.js:102 m/this.fnDestroy() jquery.dataTables.min.js:79 ViewSO/<.success() SalesOrderList.aspx:514 m.Callbacks/j() jquery.min.js:2 m.Callbacks/k.fireWith() jquery.min.js:2 x() jquery.min.js:4 .send/b()

My app calculates the results of a row search (more accurately, filter) outside of the DataTables instance because the results need to be available to multiple components. The search results are always a subset of the original rows DataTables displayed. What is the best way to get DataTables to display these results? Search plug-ins cannot be passed the results as a parameter and don't appear to have access to information beyond the DOM. (Search results are not available in the DOM.) Currently, the app simply clear()'s all the rows in the DataTables instance and then re-add()'s the subset data as if I were creating a new table. Not ideal, and I'm worried about performance. I love DataTables. Is there a better way?

My code is dynamic. I have 2 scripts. In one I have my DataTable initialized and in the second, I have my button handlers. I want to access my DataTable from outside the script. Right now, the problem that I am having is that since the Event handlers are bound only to the currently selected elements, I am not able to get all the selected rows in my DataTable, as the button click only considers the current page of the DataTable and neglects any selected rows in other pages(due to pagination). Is there a way to access the DataTable from outside the script where it is initialized?

HI, i am using Datatable v 1.10.4. and i am using serverside with pipeline and bStateSave true. i have piepeline of 5 pages when is reach to page no 3 and move to other link and come back to this page its shows page no 3 but shows data of first page.

this is my function from which i am getting an array which looks like var newx=[ ["y","y","y","y","y"], [x,x,x,x,x], [x,'Internet Explorer 5.0','Win 95+','5','C'] ]; function threshold_table(objid){ for(i=0;i<threshold_dict.thresholds.length;++i){ if(threshold_dict.thresholds[i].objectTypeId==objid) { var test=[threshold_dict.thresholds[i].type,threshold_dict.thresholds[i].name,threshold_dict.thresholds[i].id,threshold_dict.thresholds[i].ownerId,threshold_dict.thresholds[i].subsystemId,threshold_dict.thresholds[i].objectTypeId,threshold_dict.thresholds[i].comments,threshold_dict.thresholds[i].recovery,threshold_dict.thresholds[i].month]; threshold_array.push(test); } } } $('#threshold_table').DataTable({ "data":threshold_array });

Hello, I dinamically fill a datatable with the code below : var myTab = $("#mv_table_comp").DataTable().clear(); for(var i in datas) { var tmprow = myTab.row.add( [ datas[i].name , datas[i].mParam, datas[i].text ] ).node(); $(tmprow).data("id_user", datas[i].id_user).on("click", function(event){ReadSheet($(this).data('id_user')); }); } myTab.draw(); It works fine. Now, i'd like to add data("sort", myValue) to the third cell of my row... How do i do that ? Thx in advance

$("#reportTable").dataTable({ "sAjaxSource" : 'dataTablesAction.action', " sAjaxDataProp":"resultList", "sServerMethod": "POST", "deferRender": true, "scrollX": "100%", "aaSorting":[], "aoColumns": [ null, {"sClass":"td_totalamt totalamt", "mData": null,"sType" : "numeric"}, {"sClass":"td_totalplr totalplr", "mData": null,"sType" : "numeric"} ], }); I wana to add total player and total amount in last two column. Right now i am doing this work with jquery, but in this case sorting of perticular columns does not work . it sort according to first column. and at the time of sorting it change the width of these two column. if i use "defaultContent":"" in place of mData=null and set the data through jquery, width remain ok but sorting functionality does not works Please help and thanks in advance for help.

scroller forgets "past" as I scroll through my table with lots of entries and makes it therefore unreachable by the DOM in certain situations. Is there a way to make it stop forgetting?

So I use the fnRowCallback event to dynamically calculate and insert the average of the whole row in the last column called Average. The column is defined in the json.aoColumns. However, it is not sortable. Is there anyway to make it sortable? It shows the sort icon but when I click on it it doesn't do anything but changing the sort icon. [code]"fnRowCallback": function (nRow, aaData, iDisplayIndex, iDisplayIndexFull) { var iRowTotal = 0; for (var i = 0; i < aaData.length - 2; i++) { if (aaData[i + 2] != "") iRowTotal += parseInt(aaData[i + 2], 10); } iRowTotal = parseFloat(iRowTotal / (aaData.length - 3)).toFixed(2); lastColumn = aaData.length - 1; $('td:eq(' + lastColumn + ')', nRow).html(iRowTotal); }[/code]