Search

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.

use "DataTables individual column filtering example (using select menus)"

I'm looking at using the External Form functionality found at http://jquery-datatables-column-filter.googlecode.com/svn/trunk/external.html, but I see that the page is using version 1.3.2 of the plug-in, but the download zip gives me 0.9.0. Is 1.3.2 considered latest and reasonably stable? I'd want the functionality but wanna make sure I get the version I should be using.

using the code from filtering example: [code]$.fn.dataTableExt.afnFiltering.push( function( oSettings,