+1Hey, I’d like to create a segment of users with multiple WHERE clauses that are connected with an OR operator. This is what I’m looking for
Administrators
WHERE ADMIN = true
OR
WHERE APPROVER = true
But apparently only AND is possible? I’m not sure how I can create a segment with both user properties.
Best answer by Saish Redkar
Hey
Currently, I think the OR clause works only in the case where you have to filter on multiple values of the same property in an event segmentation chart. By default, adding another WHERE clause creates an AND clause between the two properties as you mentioned.
From what I know, you can achieve this directly using a behavioral cohort if you have access to it.
A custom event might also help depending on your end use case and the events in question.
Hope this helps.
+10Hey
Currently, I think the OR clause works only in the case where you have to filter on multiple values of the same property in an event segmentation chart. By default, adding another WHERE clause creates an AND clause between the two properties as you mentioned.
From what I know, you can achieve this directly using a behavioral cohort if you have access to it.
A custom event might also help depending on your end use case and the events in question.
Hope this helps.
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. You can also create a Guest account below!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. Want to sign up as a guest? Create a Community account.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
