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 :
Microsoft Dynamics 365 | Integration, Dataverse...
Answered

Filtering Criteria on N:N relationship (find records which have specific N:N relationships)

(0) ShareShare
ReportReport
Posted on by 20

I have a custom "Bounty" entity with a N:N relationship to another custom Category table. Is it possible to query using FetchXML to filter for bounties that have specific N:N relationships? So, if if a bounty has N:N relationship to a Category of "Rice" and another relationship to a category of "Software", is it possible to filter the bounties to find those that have at a minimum (Rice and Software) as categories?

I don't think this is possible with the dynamics 365, but i just wanted to confirm. Note that I don't need to use FetchXML, i am open to using any method provided by the SDK.

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    on at
  • Mildsevenintl Profile Picture
    20 on at

    Thanks for your answer Leah.

    debajmecrm.com/.../

    The above link provides a way for filtering based on N:N relationships with fetchXML.

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!

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Pallavi Phade Profile Picture

Pallavi Phade 102 Super User 2026 Season 1

#2
ManoVerse Profile Picture

ManoVerse 58 Super User 2026 Season 1

#3
Abhilash Warrier Profile Picture

Abhilash Warrier 55 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans