Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / How to create a view b...
Customer experience | Sales, Customer Insights,...
Answered

How to create a view bases on related entity

(0) ShareShare
ReportReport
Posted on by JD_G 80

Hi folks,

Some background for this question: I'm trying out an anonymization app wich uses workflows on the Contact entity.

I need to create a view with contacts that do not have a record with certain properties in a related entity. 

Example: the contact has a related entity called A, which has some fields 1, 2 and 3. I only need to see contacts with this related entity where the field 2 is always empty. If there's even one record in the related entity that has data in field 2, then I don't want to see the contact.

No atter what I try, I can't seem to set the filter properly. Either I end up with no contacts or with contacts that do have a record with field 2 filled.

Is there a way to do this or should I look fot other options?

Thanks!

  • Esteban Coto Alfaro Profile Picture
    Esteban Coto Alfaro on at
    RE: How to create a view bases on related entity

    Hello, I recommend to check this documentation of "Query data using the Web API": docs.microsoft.com/.../query-data-web-api

    For example: /api/data/v9.0/contact&?select=name,lastname,email&$expand=related_entity($select=field_1$filter=field_2 eq null)

    Thanks!

    Community Support Team - Esteban

    If this Post helps, then please consider Accept as solution to help the other members find it more quickly.

  • Kunal.Chopra Profile Picture
    Kunal.Chopra 85 on at
    RE: How to create a view bases on related entity

    Hello JD,

    What is relationship type between 2 entities  ?  Ref - docs.microsoft.com/.../relationshiptype

    Have you tried reporting with Advanced Find ? Ref - docs.microsoft.com/.../save-advanced-find-search

  • Verified answer
    a33ik Profile Picture
    a33ik 84,323 Most Valuable Professional on at
    RE: How to create a view bases on related entity

    Hello,

    That is doable from the platform perspective but there is one limitation - you won't be able to design that view using a standard approach and you will have to use View Designer in order to work with that view. Check this post that describes scenario that is close to yours - www.arbelatech.com/.../creating-system-views-with-complex-not-in-filter-in-dynamics-365-for-customer-engagement.html

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans