Search

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

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

Hi 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?

the same thing with filtering, but I can't seem

I 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.

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.