Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM forum
Unanswered

Need to find a way to display Parent entity data based on certain data from its child entity

Posted on by 1,582
Hi I am outlining a scenario here
 
Suppose I have an Account and Opportunity data in CRM and I need to find out all accounts that have at least two different opportunities records with given countries and capital matching as in condition.
 
Example :  
 
Account 1: BMW
Opportunity 1: Country : India  Capital : Delhi
Opportunity 2: Country : United Kingdom  Capital : London
Opportunity 3: Country : Itlay  Capital : Rome
 
Account 2: Tata Motor
Opportunity 1: Country : Germany Capital : Berlin
Opportunity 2: Country : United Kingdom  Capital : London
 
Account 3: Maruti
Opportunity 1: Country : France Capital : Paris
Opportunity 2: Country : United Kingdom  Capital : London
 
Account 4: Hyundai
Opportunity 1: Country : Itlay   Capital : Rome
Opportunity 2: Country : India  Capital : Delhi
 
Here in Opportunity entity have Country and Capital as two different fields.
 
I want to list accounts where it should be with two opportunities records having India+Delhi and Itlay+Rome
  • Account 1
  • Account 4
 
  • Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    Need to find a way to display Parent entity data based on certain data from its child entity
    Hi,
    It is difficult to retrieve records to get a list based on whether the related record field values are the same.
    You can consider that using fetchxml to get parent records based on child records. 

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,420 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,672 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans