Nested and statements and or statements

How To
1

Hi,

Trying to filter some shopify records. We are looking for items containing fruit AND due tomorrow.

I have the individual pieces working but…

I want it to be something like 'if items are ('bananas, strawberry, or blueberry) and (date = tomorrow).

I know I can do contains, apples or contains strawberry or contains blueberry, but then I add the ‘and’ date filter and it’s only applying it to the last ‘or’ of blueberry.

How do I say to look for one of those 3 words in a text field AND that a date has to match. I don’t see any parenthesis options in the filter screen.

3

Hey @mchinsky

You can use filter like this

Fruit contains banana AND date = tomorrow
OR
Fruit contains strawberry AND date = tomorrow
OR
Fruit contains blueberry AND date = tomorrow

2 Likes
4

Thanks. that worked. I’m surprised there is no ‘parenthesis’ so you don’t have to avoid repeating it over and over.

2 Likes
5

@mchinsky

We are glad your problem is solved. Please mark this solution as solved so it will help the community.

3 Likes