Search

have another issue. The Search, sorting, filtering abilities don't

The problem is when I type more than one word it gives no result. Everything else works fine now. I need to search for words from all columns. Vedran

To be able to control the search in this manner you can use the fnFilter API function ( http://datatables.net/api#fnFilter ) and built a regex string with the exact match that you want. Allan

if there is a search. // But what if there

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 }