Search

Hi all If there a way to include empty fields when filtering - as in, when filtering on a keyword, also include empty fields in the results? Thanks in advance. Chris

Hello every one, I am very thanks full to datatable forum specially to Allen for this awesome plugin. I am using this plugin ,it works fine but i have to change the position of toolbar(show and search) to the top of the page in a header div element. Can Any one please guide me for this.

to add individual column filters using aoColumnDefs ext but

I want to use this Add-On but it dosn't work! here is my code example!! [code] function CreateProductTable(TableHeader, ProductTable) { var aColums = []; var aVisible = []; var aColumnIndex = []; if (TableHeader != null) { for (var i = 0; i < TableHeader.length; i++) { var jColums = { sTitle: '', sType: '', bVisible: true }; jColums.sTitle = TableHeader[i].Parameter; var iDatenTyp = TableHeader[i].DataType; switch (iDatenTyp.toUpperCase()) { case "char": case "1": //is a character jColums.sType = ''; break; case "number": case "0": //is a number jColums.sType = 'numeric-comma'; break; } var sColVis = TableHeader[i].ColumnVisible; if (sColVis.toLowerCase() == "false" || sColVis == "0") { aColumnIndex.push(i); } //jColums.bVisible = false; aColums.push(jColums); } jQuery('#CPH_content_HF_HiddenColumns').val(''); jQuery('#CPH_content_HF_HiddenColumns').val(aColumnIndex); if (TableHeader.length != 0) { jQuery('#tableproduct').dataTable({ "sScrollY": "200px", "bJQueryUI": true, "bLengthChange": false, //show entries //"sDom": 'FT<"clear">lftFrip', // p = bPaginate, i = bInfo, t = , r = "iDisplayLength": 20, "bPaginate": true, //"sPaginationType": "full_numbers", "bProcessing": true, "bSort": true, "bFilter": true, "bAutoWidth": false, "bDestroy": true, "bInfo": true, "aaSorting": [], "aaData": ProductTable, "aoColumns": aColums, //dynamic TableHeader "oLanguage": {}, "aoColumnDefs": [ //{ "bSearchable": false, "bVisible": true, "aTargets": [9] } ], "fnRowCallback": function (nRow, aData, iDisplayIndex) { for (var i = 0; i < aData.length; i++) { jQuery('td:eq(' + i + ')', nRow).attr('id', 'CellIndex_' + i + '_RowIndex_' + iDisplayIndex); jQuery('td:eq(' + i + ')', nRow).parent().attr('id', 'RowIndex_' + iDisplayIndex); } return nRow; }, "fnDrawCallback": function (nRow, aData, iDisplayIndex) {//reinitialisierung von funktionen jQuery('#progressbar_table').hide(); initTableProductClick(); } }) .columnFilter({ ######################## here are the problems ############################# }); //TableHeader they are invisible / var oTable2 = jQuery('#tableproduct').dataTable(); for (var i = 0; i < aColumnIndex.length; i++) { var iCol = aColumnIndex[i]; var bVis = oTable.fnSettings().aoColumns[iCol].bVisible; oTable2.fnSetColumnVis(iCol, bVis ? false : true); } } } } [/code] Dosent understand what's wrong... please help me ...! Tank you Tank you ... best regards Alexander

solved Works fine, except filtering: search "templat" #=> several records

can you give some tips on how to improve ? When pagination is on i click on page 1, 2, 3, 4, 5 then i apply filter(search) term, the search result show some rows, when i clear the search text the table back to page 1. Is there some way to save state of page number after search? i would like to return to last page visited after search term. Example: If i was on page 5, then i search some text , then clear the search text i would like to return to page 5, not to page 1. Thanks.

to the global input filtering that we already have

I'm also using column filtering function of the table

I want to make an informative website to help people search through school programs. Has anyone seen a plug and play type of website that allows you to input data into a table. Then there are checkboxes that will include only entries with those words checked in the table. Basically I want to take a list of schools for a specific program that shows the state and class requirements. So you would check which states you want to include. Then you would check which classes you want to include. For example. I want Az, Co, Ne, Ny. with classes biochemisty, Anatomy physiology, Biology, gre. Then only the rows of entries that include those requirements will show in your list. In some way its kind of like ebay how you can select only search results that you want to include.

My column contain hyperlink data so when it creates select box automatically, data does not come properly in select box. Data comes like - Adult Commercial">Adult Commercial How to tell select box to take only data instead of hyperlink info? Please anyone help.