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.
We are sorry that this post was not useful for you!
Let us improve this post!
Tell us how we can improve this post?