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 / Microsoft Dynamics CRM (Archived) / Related Entity Does No...
Microsoft Dynamics CRM (Archived)
Active Discussion

Related Entity Does Not Contain Data not available in Views?

(0) ShareShare
ReportReport
Posted on by TopBadger 97

Hi All,

I was very happy when MS introduced the availability of searching within an Advanced Find where a 'Related Entity Does Not Contain Data' - it's something we'd been needing for ages.

Today I thought I'd take one of those advanced finds and make a corresponding system view for it - only to discover that it's not possible from the UI to add the 'does not contain data' part into the related entity. Is there some special reason for this or is it an oversight? Seems crazy to me to add such a useful feature but then disallow it in system views - looks like a job half done!

*This post is locked for comments

  • Kokulan Profile Picture
    Kokulan 18,054 on at

    Could you share the screenshot of your query please?

    Please see the screenshot of what I get  and also follow the links below if you would like to have read about the feature

    ScreenClip-_5B00_182_5D00_.png

    http://www.arbelatech.com/insights/blog/how-to-use-not-in-filter-in-dynamics-365-for-customer-engagement-v9.html

    www.preact.co.uk/.../new-query-rule-for-related-entities-in-dynamics-365-advanced-find

    Hope this helps

  • Rawish Kumar Profile Picture
    Rawish Kumar 13,758 on at

    Hello there,

    You are actually right. This is very well available in advanced find but not in system/public views filters. I have verified the same in my trial. 

    You can share the the views and idea here : https://experience.dynamics.com/ideas/   hopefully we could have it in future.

  • David Jennaway Profile Picture
    David Jennaway 14,065 on at

    As a workaround, I think you can apply this in system views by generating the fetch Xml in Advanced Find, and writing this to the fetchxml attribute of the savedquery. The are 2 ways to update the fetchxml attribute:

    1. Programmatically via the CRM API - you can update a savedquery record like any other record
    2. Create an unmanaged solution containing the view. Export it, then edit fetchxml within the customizations.xml, then reimport
  • TopBadger Profile Picture
    TopBadger 97 on at

    Thanks David,

    We took option 2. I do find it odd that the UI doesn't support the full capability of FetchXML (including other items too, like being able to do an OR between related records). It's utterly a limitation of the UI and not the underlying search, which seems entirely avoidable.

  • che Profile Picture
    che 67 on at

    Hi David

    i have the same problem , i choose NO.2 to resolve this problem but after i import my solution ,i can't see the customized view in my system view list in advance find, do you have any ideas?

  • Nandha Shanmugam Profile Picture
    Nandha Shanmugam 45 on at

    I was able to create a system view and then update it using XRMToolBox -> View Designer. This worked as expected.

  • Inam Profile Picture
    Inam 215 on at

    I was able to create personal view and update it on XrmToolBox -> View Designer.

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!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans