.I have a column that in MySQL is defined as BOOLEAN. (so it stores only 0 and 1)
|
1 2 3 |
$grid->setColProperty('mycolumn', array("stype"=>"select", "searchoptions"=>array("clearSearch"=>false, "value"=>"1:1;0:0"))); $grid->toolbarfilter = true; |
The filter appears in the toolbar but when I select something, it does not select any rows (empty table) as if there were no 0 or 1 values in that column in any of the rows, but there are plenty.
What am I doing wrong?
Hello,
As per MySQL documentation boolen type is defined as tinyint – ie:
These types are synonyms for TINYINT(1). A value of zero is considered false. Nonzero values are considered true:
We have defined such values and used your definition. The search works perfectly.
If you need a demo we can prepare such one.
I recommend you to set the debug to true and look at the log file when you search this field what is happen.
Kind Regards,
Will
Guriddo Support Team
Copyright 2014 TriRand LtdAll Rights ReservedRSS
Back to Top
