745
Hi Guyz,
Need help in creating segmentation query for 1 to N related entity
i have a custom entity let it be for example CHILDREN having lookup of contact or its grid on contact form
i need to create segments for contacts for eg. having No children ,have children (means having a record in CHILDREN entity
Put your top query block to just Contacts (and other direct criteria you are after) then Add another Query Block below it and then you can use the or, and also, but not between the 2 query blocks
e.g.
Query block 1: Contacts
but not
Query block 2: Contacts where related entity status = xxxx
(ie. in the above Exclude the Contacts that are found on Query block 2)
(but not = Exclude from the Segment, and also = Intersect of [e.g. where only on both blocks])
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
