Search

Hi, I tried to use this code from Allan : http://live.datatables.net/piqidoqo/1/edit I've modified the source like this : // Simple server-side processing $(document).ready(function() { // Setup - add a text input to each footer cell $('#example tfoot th').each(function() { var title = $(this).text(); $(this).html('<input type="text" placeholder="Search ' + title + '" />'); }); var table = $('#example').dataTable({ "processing": true, "serverSide": true, "ajax": { url: 'data.cfm', dataSrc: 'persons', complete: function(xhr, textStatus) { console.log('Statuscode : ' + xhr.status); } }, "initComplete": function() { var api = this.api(); // Apply the search api.columns().every(function() { var that = this; $('input', this.footer()).on('keyup change', function() { if (that.search() !== this.value) { that .search(this.value) .draw(); } }); }); } }); }); Status code 200 is returned when a stringis is typed, but filter is not applied ... Thanks for help Marc

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.