Need help creating an AND OR filter using Beast Mode

malmy · 2022-06-01T20:07:31+00:00

There was an error rendering this rich post.

I need my data to filter based upon a couple of criteria.

If the database column titled source_name equals 'shopify_draft_order', I need the data to show.

Also, if the database column titled referring_site is blank and another column titled landing_site contains the word 'invoice', I need that data to show as well.

Not sure if I am close or not, but here's what I've come up with so far and assuming I would need to do this in Beast Mode:

CASE WHEN `source_name` IS 'shopify_draft_order' OR WHEN `referring_site` IS NULL AND `landing_site` CONTAINS 'invoice' THEN...

Any advice would be greatly appreciated.

Find more posts tagged with

Accepted answers

GrantSmith

Try something like this:

CASE WHEN `source_name` = 'shopify_draft_order' OR (`referring_site` IS NULL AND `landing_site` LIKE '%invoice%') THEN
  [DO STUFF HERE WHEN IT MATCHES YOUR CRITERIA]
END

All comments

GrantSmith

Try something like this:

CASE WHEN `source_name` = 'shopify_draft_order' OR (`referring_site` IS NULL AND `landing_site` LIKE '%invoice%') THEN
  [DO STUFF HERE WHEN IT MATCHES YOUR CRITERIA]
END

malmy

Thank you! Super helpful.