-
SOQL to fetch account details through a AccountContactRelation object in Salesforce
Hi,
I am stuck with a problem here.
I have enabled multiple Accounts to Contact in my salesforce org. This creates a junction object called AccountContactRelation.
I need to write a query which would fetch the account details like Account id, name, record type of the Accounts linked to a Contact.
Condition is, only those account details should be fetched where the contact has more than one account linked to it.
Can someone please help. It is urgent
Thanks!
-
1 Reply
-
Hi Martina,
You can use SOQL Query something Like this :
[Select AccountId from Account group by ContactId having count(Name) > 1];
Thanks.
Log In to reply.
Popular Salesforce Blogs
Top New Salesforce Winter ’20 Features
Salesforce is back with Winter Release. Every year, Salesforce announces three releases packed with features that enhance the Salesforce experience for the admins, developers, and Salesforce users.These…
DevOps For Salesforce - All You Need To Know
While most modern software development is Agile, small and medium scale businesses do not have the opportunity nor the resources to move in that direction. Most…
All About Batch Class in Salesforce | The Developer Guide
Batch Apex is used to run large jobs (think thousands or millions of records!) that would exceed normal processing limits. Each time you invoke a…
Popular Salesforce Videos
Learning Path and Pay Scale for Salesforce Profiles
Now it's high time to know about the Learning Path for the different Salesforce profiles. In this video, you also got to know about the…
How Easy (or Difficult) is it to Transition from Salesforce Classic to Lightning Experience?
This video answers the question of: How Do You Transition Your Company from Salesforce Classic to Lightning Experience? ▪️ How difficult is it? ▪️ How long should…
Schedule Batch Apex | Asynchronous Apex in Salesforce | Learn Salesforce Development
Watch this video tutorial to learn how to schedule batch apex in Salesforce. If you have any doubts or concerns do let us know in…
