Search
11430 results 8971-8980
Forum
- 4th Dec 2014Filtering rows that have hyperlinksI 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!
- 10th Nov 2014Server Side filtering displaying on front end, and sometimes not executing.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.
- 5th Oct 2014Filtering not working with word of more 4 letterHello 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
- 13th Sep 2014Integrate AdSense in a row without affecting filtering data sourceI'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 :)
- 18th Aug 2014DCJS Datatable Footer with two rows: 1/Sum 2/Columns filtersHi 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
- 7th Aug 2014Filtering when using server-side processing with PHP and MSSQLI'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!
- 23rd Jun 2014Individual Filtering: Placeholder doesn't work correctly in IEhttp://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,
- 13th Jun 2014reading searches and filters when in client-side mode?to keep searching and filtering on the backend, but
- 16th Apr 2014Individual column filtering (using input and select menus) - server sideOlá 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]
- 26th Feb 2014Filtering on changed cellsHello, 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