Search

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.

Hi - I have a table here: http://www.vegfestwindsor.ca/2016-sponsors/ and I don't like how you have to horizontally scroll to see the last column info. If I de-activate the "allow horizontal scroll" button, then the words on the last column cut off. Is there a fix for this? Thanks

hello my problem was in detail of rows. in one of my project automatic + show to each row and that show details for rows but i used it in other project but on that the + wasn't show. how i can solve my problem?

I'm trying to use orderData to sort via a hidden column. This works inside my columnDefs: { "targets": ['cleanup'], "visible": true, "searchable": true, "orderData": [ 12 ] }, However, I'd rather choose the sorting column based on its classname, such as { "targets": ['cleanup'], "visible": true, "searchable": true, "orderData": [ 'cleanup-timestamp' ] }, However, doing so gives me an Uncaught TypeError: Cannot read property 'sType' of undefined Is it possible to indicate which column I'd like to use as sorting criteria given its th's classname, rather than column index?

I have an example https://jsfiddle.net/wwisner/kbod2o1d/#&togetherjs=KmKCxN0RPH The row with Tiger will show that the column 'Very Long Description' is running off the page. I would like this column to wrap when responsive causes it to hide. I have looked through the documentation and can't find a solution. I tried to create a class and apply that class to the column but that did not work for me. .td-limit { max-width: 70px; text-overflow: ellipsis; white-space: nowrap; overflow: hidden; } "targets": 1, "className": "td-limit",

buttons: [ 'copy', 'csv', 'excel', { extend: 'pdfHtml5', title: 'Top 10 Album CDH', customize: function (doc) { doc.content[1].table.widths = [ '*', '*', '*'], doc.content[1].table.body = {alignment:'center'} }, download: 'open' } this my function button pdf, i have 2 column number but align on left, i want change to right

Hi, I save the state on a DataTable 1.10.9, and wanted to restore the search criteria below each column after a reload of the page. I tried to use the stateLoadParams event but is is never called. My other option is to use the stateLoad option, but I'm having trouble traversing the data variable. Any help is welcome, thanks Oliver