Reply 342674 to: AND/OR query filter doesn’t work, the behaviour is always AND
Tony Rodriguez
Support staff
December 30, 2022 at 14:23
Hello, @andrewhawk,
That is what I tried to explain to you above. Please read my previous message again carefully.
AND Query: means must be true first and second condition
OR Query: means anyone can be true from the first and second condition
So that is the reason, with OR Query, you will be allowed to search multiple colors from the filters, let’s support you have a product having red and yellow color attributes/variations, so if you set the OR query, it will check whether the color can be anyone, it will show you the result.
But with AND Query, it will only choose the single color, as it is must condition, it will not look for the other colors.
This is how it works and the default functionality.
