Search

By using the solution "Server-side". On the first page sort sql-query "ORDER BY IF (TDATE = '0000-00-00', DDATE,TDATE) DESC ". How to simulate this query for the remaining pages?

page Size is not valid for pdf

Hi Allan, We are experiencing great bottle necks with jquery curCSS. The curCSS is called from different datatable areas 11 times before the DT is fully rendered and it runs for a total of 2 seconds. We would like to cancel all those rendering and run oTable.columns.adjust(); after the table is fully rendered. Is that possible? Many thanks, Yishay

Hi Alan, Just let me know if I am using old jquery version rather that 1.12. then Datatable fixed column plugin will work? because If i add the latest jquery it is hampering my other functionality which is based on old jquery version.

nevermind, the answer is yes. Not able to delete forum posts though.

Hi i try to create table through jquery now i successfully display table and data ``` if (re.length > 0) { $("#services_schdulue").append $('#services_schdulue thead').append( "<tr><th>Concatenate</th><th>No</th><th>Status</th><th>Speed</th><th>Reference</th></tr>" ); for (var i = 0; i < re.length; i++) { if (re[i] !== null) { $('#services_schdulue tbody').append('<tr><td>' +con + '</td><td>' + re[i][1] + '</td><td>' + re[i][2] + '</td><td>' + re[i][3] + '</td><td>' + re[i][4] + '</td></tr>'); } } } var myTable = $('#services_schdulue').DataTable(); ``` I try to concatenate NO , Status and Speed column .. like this var con = re[i][1].concat(re[i][2, re[i][3]); but this show undefined result how i do that ? check this js fiddle https://jsfiddle.net/wtnwgz09/14/

Hi all, I'm using the new html data attributes feature to pass the settings of a datatable. <table data-columns="[{'visible':false,'orderable':false,'searchable':false},{'type':'string','visible':true,'orderable':false,'searchable':true,'title':''},{'type':'string','visible':true,'orderable':true,'searchable':true,'title':'Date*'},{'type':'string','visible':true,'orderable':true,'searchable':true,'title':'Name*'},{'type':'string','visible':true,'orderable':true,'searchable':true,'title':'xxxID*'},{'type':'string','visible':true,'orderable':true,'searchable':true,'title':'yyyID*'},{'type':'string','visible':true,'orderable':true,'searchable':true,'title':'Project*'},{'type':'string','visible':true,'orderable':true,'searchable':true,'title':'Progress*'},{'type':'string','visible':true,'orderable':true,'searchable':true,'title':'Taal*'},{'type':'string','visible':true,'orderable':true,'searchable':true,'title':'Special needs*'},{'type':'string','visible':true,'orderable':true,'searchable':true,'title':'Finished*'}]" data-order="[[3, 'asc']]" id="DashboardGrid"> ... </table> But this results in the following jquery error : "Uncaught TypeError: Cannot use 'in' operator to search for 'length' in [" When I put the exact contents of the "data-columns" attribute in the initialisation using script everything works fine, so there is nothing wrong with the array but with parsing it from the attribute Below my debug info http://debug.datatables.net/eduyim Any help please__

Hello We are using colReorder, colVis and responsive in our datatables. We also have a drop-down menu to select and view a different data (with different column headers). It works fine when initialized for the first time. But, when we select reinstate it with new data (by selecting from dropdown), the colVis and Responsive stops functioning. Is there a way we can reinitialize the datatable so that it adjusts according to a new table structure? Regards, Jigar

I actually have my own checkbox in the table (as part of the ajax'd content) and whenever i change the length or enter in a search parameter, the re-draw (i assume) clears any checked input. Anyway around to preserve checked inputs on search or length change?

what is the proper way to show row based on value on some column? for example i have a category column, and i wanted to show row only if the category value is "CASH". so the table will show only rows with cash category, even the data contains all category.