Segments - Is it possible to query an OR branch that includes an additional AND condition?

(0) Share

Report

Posted on by SEDE

110

I can't seem to figure out how to build an OR branch that also contains an additional AND clause...a "while also" if you will.

For example, is it possible to query the following while building a segment?

Condition 1 = Value

AND ALSO

Condition A = Value

OR Condition A CONTAINS value AND Condition B does not contain data. (i.e. Condition A contains a value while also factoring in Condition B)

I ended up having to split this into two segments, as I couldn't figure out how to do an OR branch that also includes an AND as part of its condition. It'd be nice if I could have this as part of the same segment.

Thanks!

All responses (3)

Answers (1)

SEDE 110 on at

Like (0)

Report

RE: Segments - Is it possible to query an OR branch that includes an additional AND condition?

Very easy to understand...thanks, Nya!
SEDE 110 on at

Like (0)

Report

RE: Segments - Is it possible to query an OR branch that includes an additional AND condition?

Very easy to understand...thanks, Nya!
Verified answer

Nya 29,058 on at

Like (0)

Report
RE: Segments - Is it possible to query an OR branch that includes an additional AND condition?

Hi, SEDE

If my understanding is correct, the result you need is to always satisfy Condition 1 while satisfying Condition A equals to some value or satisfying (Condition A contains a value and Condition B does not contain a value).

Here is an example of a Segment for Contacts to find out all contacts meet the following conditions:

First Name = F6

And Also Last Name = L6

Or (Last Name contains value and Account does not contain value)

Which you need to do is to split the Condition 1 into the other two conditions.

First Name = F6 and Last Name = L6

Or First Name = F6 and (Last Name contains value and Account does not contain value)

So adding two query block in your segment and setting the Condition 1 you need into both of them can achieve your request.

If this helped you, I'd appreciate it if you'd mark this as a Verified Answer, which may in turn help others as well.

Best Regards,

Nya