Tell us what you are trying to do?
Combining different custom field filters (filters for blog date, report date and webinar date) into one custom field filter (date)
This was resolved before by setting the relationship to "OR" instead of "AND", and the search was working. However, today I check again and the search is not working and there is the message inside the blue box, which I haven't seen before (see screenshot)
Hello, the "OR" fields relationship condition isn't fully supported with the "only show available options for each input" feature in Search and Pagination advanced settings. You can click the button in blue to change "OR" to "AND", then if you want to use "OR" you should select the custom search option "Always show all values for inputs" that is now hidden behind the blue message. Then you should be able to select "OR" again without seeing the blue message. Let me know if you have questions about that.
Hi, I have followed your instructions:
1. I selected the custom search option "Always show all values for inputs" that was hidden behind the blue message, after I clicked the "fix relationship" (screenshot 1)
2. I selected the "OR" field relationship (screenshot 2)
3. But the blue box is sitll appearing again (screenshot 3)
Note: The order of the screenshots are ANDOR1 -> ANDOR2 -> ANDOR3
Please let me know if I have made any mistakes when following your instructions
I have tried other filtering options (eg. constants, TODAY etc) other than "URL parameters", and the "OR" can be selected without the blue box error popping up.
So in my opinion, the problem is with the "URL parameter" option.
Okay I see what you're saying, it looks like the blue box warning is appearing unnecessarily in my local tests as well. However, the filter does seem to be returning the correct results on the front-end despite the warning. Is that what you see on your end after selecting "Always show all values for inputs"? Sorry for the delay, I'll be glad to set up a demo site so we can collaborate on this if you would prefer a more hands-on approach.