Search

Ah, setting "sType": "text" in aocolumns helped :)

it's not working when i use the oLanguage option with sUrl option (I haven't tried other options). Using Browser: FF3, Datatables: 1.6.2

Hi Mithrus, That's a nice little enhancement. It does simply shift the burden of mapping the indexes from the client-side to the server-side, but I quite like that. I've been thinking about making use of sName a little bit more - I might come back to this, and I'm sure others will find it useful! Thanks. Regards, Allan

Thanks a ton Allan! That's just perfect :) jean

Good stuff :-) Thanks for letting us know what the problem was. Regards, Allan

Good catch! Thanks very much for the detailed bug report. I'll look at including your fix in the next release version of DataTables. Regards, Allan

Sure there is better way to do, but this work api.columns( FilterColumnList ).every( function () { var column = this; var select = $('<select><option value=""></option></select>') .appendTo( $(column.footer()).empty() ) .on( 'change', function () { var val = $.fn.dataTable.util.escapeRegex($(this).val()); column .search( val ? '^'+val+'$' : '', true, false ) .draw(); } ); if ( $( column.header() ).hasClass( 'dt-render' ) ) { var cells = api.cells( null, this ); if ( Array.isArray( cells.data()[ 0 ] ) ){ // type array var sArr = cells.data(), dArr = []; // unique set of datas for ( var z=0; z < sArr.length; z++ ){ sArr[ z ].forEach( function( e ) { e = Object.values( e ); if( $.inArray( e[ 0 ], dArr ) === -1 ) dArr.push( e[ 0 ] ); }); } dArr.sort(function(a, b){ if (isNaN( a )) { var aa = a.toLowerCase(); var bb = b.toLowerCase(); } else { var aa = Number( a ); var bb = Number( b ); } if ( aa < bb ) { return -1; } else if ( aa > bb ) { return 1; } return 0; }) dArr.forEach( function ( d, j ) { var t = '<option '; if ( (d) ){ if (savedColumnsFilters){ if (savedColumnsFilters[column[0][0]].search.search.replace(/\\/g,"") == '^'+d+'$'){ t += "selected='selected' "; } } select.append( t + 'value="'+d+'">'+d+'</option>' ); } } ); } else { cells.render('display').unique().sort().each( function ( d, j ) { var t = '<option '; if ( (d) ){ if (savedColumnsFilters){ if (savedColumnsFilters[column[0][0]].search.search.replace(/\\/g,"") == '^'+d+'$'){ t += "selected='selected' "; } } select.append( t + 'value="'+d+'">'+d+'</option>' ); } } ); }; } else { column.data().unique().sort().each( function ( d, j ) { var t = '<option '; if ( (d) ){ if (savedColumnsFilters){ if (savedColumnsFilters[column[0][0]].search.search.replace(/\\/g,"") == '^'+d+'$'){ t += "selected='selected' "; } } select.append( t + 'value="'+d+'">'+d+'</option>' ); } }); } });

I connected my system with database consists of millions of data. However, the system keeps lagging once connecting. So, I plan to use the serverside processing to initialize the table to empty table so it no need to process all the data in a time (and lag). Not sure if it's a good way to deal the heavy data with the datatable. Here is my what I tried but it didnt work, <script type="text/javascript"> $(document).ready(function(){ fill_datatable(); function fill_datatable(age = '', age2 ='' ,dataGender = '') { var dataTable = $('#table_data').DataTable({ processing: true, serverSide: true, " iTotalRecords": 57, "iTotalDisplayRecords": 57, },

Guys, could anyone help me put checkboxes in this example? https://datatables.net/forums/discussion/4426/multi-column-filtering

hi, has any one done user research around column filters pattern? https://datatables.net/extensions/fixedheader/examples/options/columnFiltering.html i just want to check how much comfortable people are using this.