Search

HI, I am using server side datatable it is working fine. I want to apply the filter in each column with multiple checkbox these parameter send to server side then apply the filter as well as front end check box should be checked. how can i work this

I am using datatables jquery, When running the application, the header width is not aligned with the body width.But when I click on the header, it is getting aligned with the body width but even then there is some light misalignment.

How to preserve the actual index of rows after sorting a column with the index same during the initial loadAfter sorting the row index resets back from 0 .

Hello, Datatables, all version and plugins are updated to latest version, 1.10.11. I have datatable with responsive design, view works fine, But when i tried to get values of row when i click on button, i could not get value and console shows "Uncaught TypeError: Cannot read property 'ticket_id' of undefined" If i maximize full screen, means desktop mode can see all columns, it get correct values and page get redirected, $('#tickets_table tbody').on( 'click', '#ticket_open', function () { var ticket_data = table.row( $(this).parents('tr') ).data(); window.location.href = baseURL + 'agent/core/tickets/ticket_details/'+ticket_data['ticket_id']; }); I assume when its in responsive mode, few column becomes seperate rows and it lost relation with its parent, Am i doing something wrong? Thanks,

I was wondering if it is possible to add a new entry using child row editing, as opposed to opening a modal to accomplish that?

Hi all, i would like to ask how to do these two process together? i want to format my check box data to yes or no (case 6,7), after when i export my datatable to PDF/copy/, i do not want to export all the columns. my code can do either one only. i want to hide my column 5, which is case 4. Below source code is my datatable's javascript. $(document).ready(function() { var buttonCommon = { format: { body: function ( data, columnIdx, rowIdx ) { var returnData = ''; switch (columnIdx) { case 0: { returnData = data; break; } case 1: { returnData = $(data).text(); break; } case 2: { returnData = data; break; } case 3: { returnData = data; break; } case 4: { returnData = data; break; } case 5: { returnData = $(data).find('textarea[name=message]').val(); break; } case 6: { returnData = ($(data).is(':checked')) ? "yes":"no"; break; } case 7: { returnData = ($(data).is(':checked')) ? "yes":"no"; break; } } return returnData; } } }; var table1 = $('.dataTable').DataTable( { paging: false, dom: 'Bfrtip', stripHtml: true, buttons: [ 'copy', {extend: 'csvHtml5', text: 'CSV', exportOptions: buttonCommon,}, {extend: 'pdf', text: 'PDF', exportOptions: buttonCommon} ] } ); } );

how to solve above problems

So here is my question: http://stackoverflow.com/questions/36042224/using-jquery-datatables-js-1-10-11-the-table-doesnt-initially-show-additions-t

Hi Everyone, Kindly help with reference below code. I want the sort the data of datatable using datepicker of jquery. Could you suggest me that what should i do in this code??? $('#example tfoot th#Bkdate, th#entry').each(function () { var title = $('#example thead th').eq($(this).index()).text(); $(this).html(''); }); dataTableInstance.api().columns().every(function () { var dataTableColumn = this; $(this.footer()).find('input').on('keyup change', function () { dataTableColumn.search(this.value).draw(); }); Regards, vsverma11

I have a small image that I'm displaying for each result, in a row, using fnRowCallback. When the image loads, the search results look a little messy/blurry when typing into the search fields, as the image is being redrawn/reloaded on every keystroke. Can anyone think of a way to avoid this? I tried "searchDelay" but the redraws still seem to happen instantly, and it doesn't seem to work on individual column filtering. Ideally I'd delay the loading of the image until the search redraws have been rendered/displayed.. Many thanks in advance for any suggestions. "fnRowCallback": function( nRow, aData, iDisplayIndex ) { data = strtrunc2(aData.LastReported, 16); data = lightgem(data); $('td:eq(1)', nRow).html(data + '<a href="inv-detail.php?Serial=' + aData.Serial + '">' + aData.ComputerName + '</a>'); return nRow; }, (lightgem is a JS function I added that works out which image to display (green, red, or orange "light") depending on how old the date field is). it just echoes: '<img src="myimage.png>' This isn't a show stopper.. it just looks a bit messier than when the image isn't included.