-
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
7 Keys to a Successful Salesforce Integration
Organizations rely on multiple software and platforms to carry out specific business operations. With apps dedicated to sales, marketing, and collaboration, teams have unlimited access…
9 Reasons Why Sales Teams Struggle With Sales Results | Salesforce Guide
Sales. Yes, it is a tough job. One bad month and there are hundreds of questions to answer. No matter what the market reality is…
Files, Attachments And Notes Salesforce Lightning Components | Force.com
Download Notes & Attachments from Force.com Site of Lightning Component Create an email alert that will be sent to the Opportunity Owner. This email will…
Popular Salesforce Videos
Salesforce Winter '22 Innovation Spotlight: Sales, Service, & Financial Services
Improve employee performance and grow your business with the newest features from Sales, Service, and Financial Services Cloud! Watch this video and get to know…
How Admins Can Improve Salesforce Data Quality
Learn how to diagnose the accuracy of your data and build a plan to maintain and enhance its’ quality using Salesforce tools. Follow along to…
Governor Limits in Salesforce | Video Tutorial
Watch this amazing video to learn all about Governor Limits in Salesforce and a description of Governor Limits in Salesforce. If you have any doubts…
