Search

use different data for search, sort and display. It

Allan, I have same request, where there is no record returned in json data, user still has option to play with pagination, search and sorting. Is it possible to hide those features from user? Thanks, Samir

The search option can be used to define an initial search term when the DataTable is created. Allan

How are you doing the search. Are you using the search() method? As I noted, you can't use the default search (i.e. the default input box) since it always does a contains. Allan

line before the actual search, but I kept the

If you want to remove the search, page length etc, you use the dom option that I suggested above. Allan

Here is the Microsoft documentation for SQL server's regex. Since you are using server-side processing, you would need to modify your GetSearchResults script to do the regex search. Allan

@daniel_r This is not what I want. See, I want to exclude a single (specific) column from global search. Any other solution ?

you don't want the search box remove the f

Got it. With SSP you could use: dt .search('') .one( 'draw', function () { dt.page('last').draw( false ); } ) .draw( false ); Not ideal, but it would stop any timing issues. Allan