Search

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.

Hello guys, I've implemented this example: http://datatables.net/release-datatables/examples/api/multi_filter_select.html Inside a table of mine which contains 8 columns. Everything is great excepting for the fact that inside the 1st column I have a text string linked to an .html page. When populating the dropdown menu that is displayed under that 1st column I see: TextString">TextString Inside that column I have: TextString The only thing that I've changed is: $(document).ready(function() { /* Initialise the DataTable */ var oTable = $('#example').dataTable( { "oLanguage": { "sSearch": "Search all columns:" } } ); Changed into: $(document).ready(function() { /* Initialise the DataTable */ var oTable = $('#example').dataTable( { "sPaginationType": "full_numbers", "iDisplayLength": 25, "oLanguage": { "sSearch": "Search all columns:" } } ); I've tried to add also: "aoColumns": [ { "sType": "html" }, { "sType": "string" }, { "sType": "string" }, { "sType": "string" }, { "sType": "string" }, { "sType": "string" }, { "sType": "string" }, { "sType": "string" } ], just after the 'iDisplayLength' parameter, but this didn't make any difference. What's wrong? Thanks, Mihai

I use data table plugin for my grid view it works fine for searching,sorting but i want searching like in the following link with jquery UI slider http://jiren.github.com/filter.js/filterjs.html and searching with check box but not getting idea how to do it when i change something in my code the slider gets disapear help me to get out of it please provide any working code here is my .aspx jquery code jQuery(document).ready(function($) { $(function(){ var options = { range: true, min: 500, max: 1000, values: [500, 1000], slide: function(event, ui) { min = ui.values[0], max = ui.values[1]; $("#amount").val("Rs." + min + " - Rs." + max); }, stop: function(event, ui) {//This event is triggered when the user stops sliding. oTable.fnDraw(); } } $("#slider-range").slider(options); min = $("#slider-range").slider("values", 0); max = $("#slider-range").slider("values", 1); $("#amount").val("Rs." + min + " - Rs." + max); }); $('#').dataTable({ "bJQueryUI": true, "bPaginate": false, "bLengthChange": false, "bFilter": true, "bSort": true, "bAutoWidth": false }); });