Search

I have a datatable where I show online users are hyperlinks , which can be clicked to start a chat. I want to introduce a checkbox, which when clicked will hide offline users. I have tried a lot of different things with $.fn.dataTableExt.afnFiltering.push() but in vain. My datatable object is in data_table variable, which I initiate as under data_table = $('#online_users_table').dataTable(); Please help me in hiding offline users when the checkbox is checked. Thanks!

http://www.qbhitlist.com/rankings/qbhl-premium-player-rankings/ If you go here only pro style players from 2015 are supposed to show. All players show, and then eventually (most of the time) go away. Any thoughts on this? Can post code if needed.

Hello have a problem, I try to do datable with filtergin for each column but not work just for a word of 3 letter, if I write a word large the message is: File or directory not found-- The resource you are looking for might have been removed, had its name changed, or is temporarily unavailable. anyone know what is the problem ??? thanks

I've been stuggling with it too much time already and didn't come up with an ultimate solution yet. Doing the colspan with empty TDs (display: none) for rest of the table worked for some browsers but yield exception in IE, removing the colspan would ruin table cells design... Please assist :)

Hi all, I got a dcjs dashboard set up with Datatables and working perfectly. At the moment my footer has only one row that gives the individual sum of two of the columns. window.dataTableJUI = $("#dc-data-table").DataTable({ "dom": "<'row'<'span6'><'span6'f>r>t<'row'<'span6'il><'span6'p>>", "lengthChange": true, "info": false, "autoWidth": false, "deferRender": true, "data": alldata, "destroy": true, "footerCallback": function ( row, data, start, end, display ) { var api = this.api(), data; // Remove the formatting to get integer data for summation var intVal = function ( i ) { return typeof i === 'string' ? i.replace(/[\$,]/g, '')*1 : typeof i === 'number' ? i : 0; }; // Total for "Avails" column over all pages dataAvails = api.column( 6, {search:'applied'} ).data(); totalAvails = dataAvails.length ? dataAvails.reduce( function (a, b) { return intVal(a) + intVal(b); } ) : 0; // Total for "Forecast" column over all pages dataForecast = api.column( 7, {search:'applied'} ).data(); totalForecast = dataForecast.length ? dataForecast.reduce( function (a, b) { return intVal(a) + intVal(b); } ) : 0; // Update footer $( api.column( 1 ).footer() ).html( 'Avails total: ' + totalAvails.toString().replace(/\B(?=(\d{3})+(?!\d))/g, ",") + " // Forecast total: " + totalForecast.toString().replace(/\B(?=(\d{3})+(?!\d))/g, ",") )}, "columnDefs": [ { "targets": [ 0 ], "data": "col1", "defaultContent": ""}, { "targets": [ 1 ], "data": "col2", "defaultContent": ""}, { "targets": [ 2 ], "data": "col3", "defaultContent": ""}, { "targets": [ 3 ], "data": "col4", "defaultContent": ""}, { "targets": [ 4 ], "data": "col5", "defaultContent": ""}, { "targets": [ 5 ], "data": "col6", "defaultContent": ""}, { "targets": [ 6 ], "data": "avails", "defaultContent": ""}, { "targets": [ 7 ], "data": "forecast", "defaultContent": ""} ] }); I would like to add a second footer row with column-wise search boxes, like shown here Although it is fairly easy to create the boxes with jquery, I cannot get them to be linked to rest of the table. This makes me think that I should maybe define them in the "footerCallback" but I don't have any idea where to start. Thanks a lot

I'm using DataTables with PHP and a MSSQL server. I'm using the server-side processing example and it works perfectly if I want all of the data. If I want to add a WHERE statement, where do I do that? The examples and forum questions address how to do it when using MySQL, but I haven't seen any examples of doing this with MSSQL. Thanks!

http://live.datatables.net/micihuz For the sake of meeting the test case requirement, my example is above copies the code directly out of the example found here~~~>http://datatables.net/examples/api/multi_filter.html In order to reproduce my error, you have to open either the example or the test case in IE8. I've only tried it in IE 8, but as I understand it, the error occurs in all versions of IE. Basically, IE doesn't support HTML5 input placeholders. I've attempted to use modernizr and a few other scripts that are supposed to get around this issue, but I haven't been able to get anything to work successfully in conjunction with datatables. Is there a way to get the input placeholder to work in IE? If so, could anyone provide an example. Thanks,

to keep searching and filtering on the backend, but

Olá a Todos! É possível carregar os dados do filtro select a partir dos dados do lado servidor? Até que consegui fazer este carregamento colocando "bServerSide": false e aoColumns: [ { type: "select" } ] porém o carregamento fica super lento. Alguém pode me dizer se é possível ou não. E se possível informar como devo proceder? Abaixo o meu código... Abraços... [quote] var oTable = $('#dt_basic').dataTable({ "sPaginationType" : "bootstrap_full", "iDisplayLength": 10, "aLengthMenu": [[10, 30, 50, 70, 99], [10, 30, 50, 70, 99]], "bAutoWidth": false, "bSortCellsTop" : true, "aaSorting":[[0, "desc"]], "aoColumnDefs": [ { "bSortable": false, "aTargets": [ 0,6,8 ] }, { "sClass": "center", "aTargets": [ 0,1,2,3,4,5,6,7,8,9,10 ] } ], "oLanguage": { "oPaginate": { "sFirst": '<i class="fa fa-fast-backward"></i>', "sPrevious": '<i class="fa fa-backward"></i>', "sNext": '<i class="fa fa-forward"></i>', "sLast": '<i class="fa fa-fast-forward"></i>' }, "sInfoThousands": ".", "sZeroRecords": "Nada foi encontrado - desculpa", "sInfo": "_START_ a _END_ de _TOTAL_ registros", "sInfoEmpty": "Mostrando 0 até 0 de 0 registros", "sInfoFiltered": "(filtro a partir de _MAX_)", "sProcessing": "Aguarde..." }, "bProcessing": true, "bServerSide": true, "sAjaxSource": "php/server_processing.php", "fnServerData": function( sUrl, aoData, fnCallback ) { $.ajax({ "url": sUrl, "data": aoData, "success": fnCallback, "dataType": "json", "cache": false }); }, "sDom" : "<'dt-top-row'Tlf>r<'dt-wrapper't><'dt-row dt-bottom-row'<'row'<'col-sm-6'i><'col-sm-6 text-right'p>>", "oTableTools" : { "aButtons" : [{ "sExtends": "text", "sButtonText": "<i class='fa fa-filter'></i> Limpar", "fnClick": function ( nButton, oConfig, oFlash ) { var oSettings = oTable.fnSettings(); for(iCol = 0; iCol < oSettings.aoPreSearchCols.length; iCol++) { oSettings.aoPreSearchCols[ iCol ].sSearch = ''; } oTable.fnDraw(); $("#dt_basic :input").each(function(){ $(this).val(''); this.style.color = "#999"; }); } },{ "sExtends": "copy", "sButtonText": "<i class='fa fa-files-o'></i> Copiar", },{ "sExtends" : "collection", "sButtonText" : '<i class="fa fa-floppy-o"></i> Salvar <span class="caret" />', "aButtons" : [{ "sExtends": "download", "sButtonText": "Excel", "sUrl": "php/generate_csv.php" }], } ], "sSwfPath" : "js/plugin/datatables/media/swf/copy_csv_xls_pdf.swf" }, "fnInitComplete" : function(oSettings, json) { $(this).closest('#dt_table_tools_wrapper').find('.DTTT.btn-group').addClass('table_tools_group').children('a.btn').each(function() { $(this).addClass('btn-sm btn-default'); }); } }) .columnFilter({ sPlaceHolder: "head:after", aoColumns: [ { type: "text" }, { type: "text" }, { type: "text" }, { type: "text" }, { type: "text" }, { type: "text" }, { type: "text" }, { type: "text" }, { type: "text" }, { type: "text" }, { type: "text" } ] }); [/quote]

Hello, I have a table created from html, on which i change the cell data of a column by an ajax call. The column with the updated cells are not visible and only used for searching the table. But it looks like the search is using the old data, which was there when it got initialized. What I'm doing wrong? I've made an example: http://live.datatables.net/qononub/2/edit Thanks