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
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.
Was this reply helpful?YesNo
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.
1,603
Share
Report
All responses (
Answers (
