how to use column filter in server side..
how to use column filter in server side..
vishalndobariya
Posts: 3Questions: 0Answers: 0
i m using column filter normal than it's working but i m using column filter server side it's not woking can guys help me?????
This discussion has been closed.
Replies
Try searching the forum; this has been asked and answered several times.
The search value is returned in the url via the "search" parameter.
You need to construct your own server side query that would search the fields containing the Search value.
If you only have a single column "name", something like
"select * From table where where like '%" + sSearch +"%'" might work where search is read from the request variables of the URL.
But, it really needs to be far more complex to handle break characters, multiple columns, determine whether you want full text search,etc.
When doing server side ajax, you are responsible for everything. There are some supplied simple search scripts for PHP. But for other languages you need to construct them.