DataAssist Wizard - Search with Multiple Checkboxes - Incorrect Results
When I run the DataAssist Wizard to create my search.php/results.php pages, my search page has the following:
First Name - textfield
Last Name - textfield
ID# - textfield
Included In Group A - checkbox
Included In Group B - checkbox
The pages are generated properly, however the search does not work properly when I include the two checkbox fields. It always returns 'no results'. To get any results, I have to check both boxes, which is not how the data actually looks.
I cannot find any tutorial/guides related to this. Both fields related to the checkboxes are as follows in my database:
IncludedInGroupA enum ('Y','N')
IncludedInGroupB enum ('Y','N')
I have tried selecting the checkboxes on the search page, and changing the checked value to 'Y' but still no success.
Attached are a couple screenshots to help illustrate.