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
Thanks LA
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])
André Arnaud de Cal...
292,111
Super User 2025 Season 1
Martin Dráb
230,934
Most Valuable Professional
nmaenpaa
101,156