krishna asked 6 years ago
Hi abu
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
1 Answers
Abu Ghufran answered 6 years ago
Hello,
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.
Your Answer
