Bug #7052
Updated by krileon over 6 years ago
If using a multi-checkbox the OR case is not contained in brackets properly (wrong place) causing additional search criteria to be incorrectly added. Current: ( ( ( ue.`cb_checkboxmultiple` LIKE '%Value 1%' ) OR (ue.`cb_checkboxmultiple` LIKE '%Value 5%' ) AND ue.`cb_dropdownmultiple` LIKE '%Value 1%' ) ) Correct: ( ( ( ue.`cb_checkboxmultiple` LIKE '%Value 1%' ) OR ue.`cb_checkboxmultiple` (ue.`cb_checkboxmultiple` LIKE '%Value 5%' ) ) AND ue.`cb_dropdownmultiple` LIKE '%Value 1%' ) https://www.joomlapolis.com/forum/255-developer-members-support/238641-search-not-working-properly#302359