Search

It is possible to exclude columns from the search by using "bSearchable": false. See the bSearchable example here: http://www.datatables.net/usage/columns

I have suppressed "sAjaxSource" at the initialisation of the datatable and the following function is called by the click on the button. it works fine, thanks !! [code] function search(){ oTable = $("#tableSearch").dataTable(); oTable.fnClearTable(); $.getJSON("/ModificationController/ajax",callBack); function callBack(data) { $.each(data, function(i,row){ oTable.fnAddData( row); } ); }; }; [/code]

Thanks again Allan. The code that you left cleared the search box but it didn't reset the table results. I added "oTable.fnFilter('');" to the code as shown below and it works great. $('div.dataTables_filter input ').dblclick(function () { $(this).val(''); $(this).keypress(); oTable.fnFilter(''); });

You can use oSearch to set the initial search string: http://datatables.net/usage/options#oSearch , and then all you need to do is get the search string from the window.location.href string. Allan

character and the datatables search fails when that character

Columns can be hidden by setting {"bVisible": false } for the columns. See here for examples: http://www.datatables.net/examples/basic_init/hidden_columns.html By default, the column will remain searchable. By setting bSearchable the column can be excluded from search too, e.g. {"bVisible": false, "bSearchable": false }

if there is any search filtering on the column

For example: http://datatables.net/ and search for 'z'. I guess

to remove the global search box, but leave the

Allan, How can I do this smart search (search "2.0 1.8") from your demo table, in server-side datatables? Thanks!