Search

https://datatables.net/examples/api/tabs_and_scrolling.html in this example Table2 is a default searched value on seacrh box, but I wanna make a clickable value and when I click it It should show the value like the Table2 in the datatable example?.

keyup change', function () { if ( column.search() !== this.value ) { column .search( this.value

Hello all, i would like add a editable column to my datatable , any solution plz ?

So i am saving a datatable state to database and the server is returning valid json {"time":"1485446348443","start":"0","length":"10","order":[["8","asc"]],"search":{"search":"","smart":"true","regex":"false","caseInsensitive":"true"},"columns":[{"visible":"false","search":{"search":"","smart":"true","regex":"false","caseInsensitive":"true"}},{"visible":"false","search":{"search":"","smart":"true","regex":"false","caseInsensitive":"true"}},{"visible":"false","search":{"search":"","smart":"true","regex":"false","caseInsensitive":"true"}},{"visible":"false","search":{"search":"","smart":"true","regex":"false","caseInsensitive":"true"}},{"visible":"false","search":{"search":"","smart":"true","regex":"false","caseInsensitive":"true"}},{"visible":"true","search":{"search":"","smart":"true","regex":"false","caseInsensitive":"true"}},{"visible":"false","search":{"search":"","smart":"true","regex":"false","caseInsensitive":"true"}},{"visible":"false","search":{"search":"","smart":"true","regex":"false","caseInsensitive":"true"}},{"visible":"false","search":{"search":"","smart":"true","regex":"false","caseInsensitive":"true"}},{"visible":"false","search":{"search":"","smart":"true","regex":"false","caseInsensitive":"true"}},{"visible":"false","search":{"search":"","smart":"true","regex":"false","caseInsensitive":"true"}},{"visible":"false","search":{"search":"","smart":"true","regex":"false","caseInsensitive":"true"}},{"visible":"false","search":{"search":"","smart":"true","regex":"false","caseInsensitive":"true"}},{"visible":"false","search":{"search":"","smart":"true","regex":"false","caseInsensitive":"true"}},{"visible":"true","search":{"search":"","smart":"true","regex":"false","caseInsensitive":"true"}},{"visible":"false","search":{"search":"","smart":"true","regex":"false","caseInsensitive":"true"}}],"ColReorder":["0","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15"]} stateLoadCallback: function (settings) { var o; $.ajax( { url: "{{path('to state load')}}", async: false, dataType: 'json', success: function (json) { o = json; } } ); return o } 1- the load state is not applying the column visibility 2- can i disable automatic state saving and only trigger save when i want , i am using DataTables 1.10.13

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/