Home › Forums › Product Support Forums › Ajax Search Pro for WordPress Support › Custom Fields LIKE/EXACTLY LIKE options does not work › Reply To: Custom Fields LIKE/EXACTLY LIKE options does not work
Thank you very much for the details, it helped me a lot!
The problem there is that the ACF checkbox is a complex field, and is stored as an Object in the database, not as a simple text field. Like so:
So exact matching won't work, as the whole text should be entered. The non-exact matching is not working because for example typing “L” matches this string even if only “XL” is selected, because it's a substring of it.
I have done some experiments and I have found a solution. To match any of these, the delimiters (double quotes) should be added to the values as well. In your case, you need to change them to:
"XS"||XS "S"||S "M"||M "L"||L "XL"||XL "XXL"||XXL
So basically encapsulate every value with the code of the double quote string aka:
This did the trick on my test environment, and hopefully for you as well 🙂Best,
If you like my products, don't forget to rate them on codecanyon :)