Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Answered

Segmentation query block add a check if a 1 to N related entity with have or doesn't have any records

(0) ShareShare
ReportReport
Posted on by 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

pastedimage1624451312451v1.png

      

    

    

  • MMK Profile Picture
    MMK 745 on at
    RE: Segmentation query block add a check if a 1 to N related entity with have or doesn't have any records

    Thanks LA

  • Verified answer
    Fubar Profile Picture
    Fubar 2,752 on at
    RE: Segmentation query block add a check if a 1 to N related entity with have or doesn't have any records

    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])

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,111 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,934 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans