web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Segmentation query blo...
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 MMK 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

      

    

    

I have the same question (0)
  • Verified answer
    Fubar Profile Picture
    Fubar 2,761 on at

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

  • MMK Profile Picture
    MMK 745 on at

    Thanks LA

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
ManoVerse Profile Picture

ManoVerse 189 Super User 2026 Season 1

#2
CU11031447-0 Profile Picture

CU11031447-0 100

#3
NeerajPawar Profile Picture

NeerajPawar 66

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans