Search

Hi guy's first of all great work thanks for this... In my web page am using more data tables in a page with tabs, I Want search one search for all data tables in page... So i used fnFilter all api... its reloved my problem, but.. when i am search it searches all tables in all tabs.. i need to search only visible tables on a page (current tab).. eg: i have 3 tables in each tab.. all are having same class for data table. and also each tab tables contains another class by tab name.. if am using [code] oTable.fnFilterAll(this.value); [/code] it searches all tables in all tabs... using this [code] var tables = $.fn.dataTable.fnTables(true); [/code] i can get the tables i want.. that means currently visible tables. but i don't know how to use this results in fnFilterAll method help me to resolve this... thanks

using datatable individual column filtering plugin,here am adding date-range

var oTable = $('#example').dataTable( { "sPaginationType": "full_numbers", "aaSorting": [], "sDom" : 'rt<"bottom"ilp><"clear">', "bFilter": true,"bInfo": true,"bPaginate": true,"aoColumnDefs": [ { 'bSortable': false, 'aTargets': [ 0,6 ] } ],"aoColumns": [ { sWidth: '5%' }, { sWidth: '20%' }, { sWidth: '15%' }, { sWidth: '12%' }, { sWidth: '12%' }, { sWidth: '20%' }, { sWidth: '15%' } ] } ); $('#txtsearch').keyup(function(){ oTable.fnFilter(this.value,null,false); return false; }); i have written above code and when i am trying to search numeric value then i get value of anchor tag and href value in result and that i don't want i want only it html value e.g. Next if i put " 45 or javascript " value in search box then result must be null.

about problems with column filtering and hidden columns but

hello, anyone know how I can restore select a field in a table columnfilter. i have the external columnfilter in a form and I want to add a botton restore it all. thanks.

the column from global filtering with "bSearchable". My aoColumns:

Hi all, I'm wondering if it is possible to exclude a column from search, but to still allow it to be individually filtered (for example using a select or text box). I'm using the standard global search, but have a select using (on change) the fnFilter() method which stops working when setting bSearchable to false on the column in question.

Hello All, I am working on ASP.Net MVC and JQuery. And using JQuery DataTable. But in one of the JQuery script, I need to add alert() function then only the script get run other wise script not get run. I am not getting actual problem and have googled a lot still didn't get solution so please help me for the same. This is my code: [code] $("#dvddl div").each(function (i) { this.innerHTML = this.innerHTML + fnCreateSelect(oTable.fnGetColumnData(i)); alert(i); /THIS IS THAT ALERT WHICH WE NEED TO ADD IN THIS CODE OTHER WISE (select)CONTROLS NOT GET LOAD/ $('select', this).change(function () { oTable.fnFilter($(this).val(), i); }); }); [/code]

I have dataTables sorting by column, now I want to add an alphabetic bar across the top of the table (a, b, c, d....) so that when the user clicks on a column to sort it, they can also click on one of the letters to bring up values in that column that start with that letter. So, if they have column 1 sorted, then the click "A", everything comes up where the values in column 1 start with the letter A. Any ideas? Thanks in advance!

Is there anyway for datatable plugin to ignore hidden rows so the alternate row color doesn't get mess up and the sInfo will display the right number of rows. When i hide a row the sInfo information of total rows does not match the number of visible rows. Same problem with filter/search. Thanks. P.S. I can not remove rows.