Home › Forums › Guriddo Suito PHP › Dropdown in toolbar seach for boolean column not working?
This topic contains 2 replies, has 2 voices, and was last updated by guriddo.support 3 months, 2 weeks ago.
I have a column that in MySQL is defined as BOOLEAN. (so it stores only 0 and 1)
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?
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.
Guriddo Support Team
It is a good idea to use the following definition to include all fields:
You must be logged in to reply to this topic.
Stay connected with us in your favorite flavor!
Copyright 2014 TriRand LtdAll Rights ReservedRSS