I store value in database Y,N
But in grid i Display Like Yes,No
Problem is :
When I search Yes It Shows Empty Row How i Rectify This problem
There are 2 solutions.
1) use Blank/Yes/No dropdown for search filter.
$col["stype"] = "select";
$col["searchoptions"] = array("value" => ":;Y:Yes;N:No", "separator" => ":", "delimiter" => ";");
2) Change field on which search should be done. e.g.
$col["dbname"] = "IF(field1=='Y','Yes','No')";
This will be use in WHERE clause and give correct result.
How useful was this discussion?
Click on a star to rate it!
Average rating / 5. Vote count:
We are sorry that this post was not useful for you!
Let us improve this post!
Thanks for your feedback!