Search

"aren't submitting the values DataTables needed for server-side processing" - no, they were getting passed in correctly. (i should have shown the searchTerms) anyway, got it finally. it was simply this: success: fnCallback, in the ajax call. fnServerData requires that unlike sAjaxSource (apparently!) :) many thanks allan...

Anything in the THEAD is excluded, anything in TBODY (including TH cells) is included. To exclude certain cells you'd need to use custom filtering. Allan

Well, finally i did it using regular expression thanks to another post i found on this forum. Here's my solution to look for something different than "No" for the column 7. [code]table.fnFilter('^((?!No).)*$', 7, true);[/code]

Many thx for the answer first of all. I just see this example but i don't understand how to merge the two examples.

[code] $.fn.dataTableExt.afnFiltering.push( function( oSettings, aData, iDataIndex ) { var account= document.getElementById('account').value; var setdata= document.getElementById('setdata').value ; var colunm1= aData[0]; var colunm2= aData[1]; if ( account== "" && setdata== "" ) { return true; }else if ( colunm1== account && colunm2 == setdata) { return true; } else return false; } ); [/code] Seem to find a solution, and very grateful to the authors developed a convenient method

Currently no - there isn't a built in way to do this, although you can easily do it using the initialisation options. You just need to parse the query string and pass the required parameters to DataTables ( iDisplayStart for example). This has come up a number of times recently, so I've made a note to write a tutorial about it in future, although if you do some up with your own solution, I'm sure others would be very grateful if you could share it! Allan

hi srimanta12, though i am not 100% sure but there is a property called "bCaseInsensitive" which by default is true why dont you make it as false and then try to filter. Arjun

That is a planned feature for DataTables 1.10: http://datatables.net/development/roadmap Allan

You haven't provided enough information for us to provide a meaningful answer. You say a "script is called" when your page loads. Is this a client-side Javascript? Server-side PHP that generates your page? Can we see the source code for this script? You are "making a query". How? Against what data? If you have a server-side process that returns JSON data, and you want your Datatable to contain that JSON data, then look at using an AJAX datasource and the fnReloadAjax() function, which you can call whenever you need the table to update.

wow. Instant response. Thanks Allan