Search

Can we use these options together is that possible. i wanna show extra information but when i use responsive:true two accordion button appears and not working https://datatables.net/examples/api/row_details.html

I have a datatable that has a daughter table, where it does not always have data to display, this my daughter table is empty. I follow this example https://datatables.net/examples/server_side/row_details.html and I would like to be able to change the className of my first column so that when there is no data for a daughter table, the expansion indicator does not appear. Here is my code that I tried to do but it did not work: columnDefs: [ { targets: 0, className: function (td, cellData, rowData, row, col) { if (row.ctes === ''){ return ''; } return 'details-control'; } } ], This way the parameters (td, cellData, rowData, row, col) do not receive any information about the line, and I can not tell if my column is null or not

I have a datatable with complex headers: A B C A.1 B.1B.2C When I use column visibility, I want to only show the top header as options: A,B,C Presently , I am seeing A, B.1,B.2,C-- It seems like this would be a simple functionality that is baked in but I have yet to find it.

have a table which contains parent and child rows. initially, i want to hide child rows when i click on parent row need to expand child row. here's what I tried: https://jsfiddle.net/Albion87/tnozsp5s/35/ [This example has another issue:] which is if I freeze the first column I won't be able to sort horizontally, if I disable freezing first column then I can sort horizontally. any idea to solve this issue

This is the situation; I have three html tables created programmatically in my php page. In document ready try to start the plugin . $(document).ready(function(){ $('.genetictable').each(function(){ var tabla = $(this).DataTable( { scrollY: 500, scrollX: true } ); new $.fn.dataTable.FixedColumns( tabla , { leftColumns: 3 } ); }); The plugin starts well, but the fixedColumn functionality don’t start until I manually click in column for order it. After new $.fn.dataTable.FixedColumns( tabla , { leftColumns: 3 } ); I try: Order programmatically : tabla.column(3).data().sort(); draw() functionality : tabla.draw( 'page' ); tabla.draw( false ); Try draw() and order functionality: table.order( [[ 3, 'desc' ]] ).draw( false ); None works The functionality also start if push f12 or inspect element in Mozilla. Any change to achive this for my multiple tables?

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