All Topics → Question → Curious – displaying a single entry based on field value works with like but not equal to
I need to display a single entry (a ‘specialist of the month’ feature) so in the form I have a checkbox “Is Specialist of the month?” with yes and no checkboxes (there is no boolean field, right?)
On the custom display in the advanced section I have put where specialist of the month is equal to Yes to get the featured entry to display but this does not work. It does work if I use LIKE instead of equal to.
Checked and double checked for spaces etc. I have it working so there is no real issue here, but was just curious why ‘equal to’ might be producing no results.
October 13, 2012 at 10:05 am
Checkbox values are saved in a serialized array. However, since you probably won't have people checking both yes and no, you might want to consider a different field type.
Topic closed.