There isn't a build in option in DataTables to do this, but there are two options that I can see:
1. Get your server to realise that there is no filter and thus return an empty result set
2. Use fnServerData and before making an Ajax request, check to see if there is a filter applied or not. If there is, then do the Ajax result as normal. If there is no filter then just call the callback function with an empty data set.
Replies
Typing where & what? Using server-side function or what?
Detailed Question with your code/illustration, etc. --> Better answers.
-- Vineet
For 5000 records list the delay.
I then list only necessary after typing in the "Search"
1. Get your server to realise that there is no filter and thus return an empty result set
2. Use fnServerData and before making an Ajax request, check to see if there is a filter applied or not. If there is, then do the Ajax result as normal. If there is no filter then just call the callback function with an empty data set.
Allan