Search
11456 results 9001-9010
Forum
- 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
- 24th Jan 2014Individual column filtering (using "select" elements)I'm using the filters for each column http://datatables.net/release-datatables/examples/api/multi_filter_select.html, I would like to know how I can do to make it have only a few columns. thank you very much in advance
- 17th Jan 2014Individual Column Filtering allowedHi All, I have a table which is generated dynamically. I want to allow sorting on few columns only not on all columns. Can anyone help me with this?
- 15th Nov 2013Applying filters via a plug-in on initializationthe same thing with filtering, but I can't seem
- 26th Sep 2013Filtering rows from a datatable with a particular column having non-zero valueI have datatable in which a non-zero value represents error condition and I want to display just those rows which have this column with some non-zero value i.e. error conditions. Could you please tell me how could I achieve it using fnFilter regular expression. I am quite unable to achieve it.
- 17th Jul 2013How to count the number of potential search results without actually filtering?Does anyone know if and how we can count the number of potential search results even before we perform fnFilter and update the table? I need this number to highlight the outcome in advance.