-
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
What Is Salesforce? How Is It Used and How Does It Impact Business?
More than 80% of the Fortune 500 companies in the world use at least one Salesforce app. Such is the deep impact and penetrative power…
Features of Salesforce Commerce Cloud: Enhancing the Shopping Experience
Commerce Cloud is a key part of the Salesforce Customer Success Platform and offers ecommerce solutions for B2C (business-to-consumer) and B2B (business-to-business) customers. That means…
How To Use jQuery DataTable Plugin In Salesforce Lightning Component?
DataTables: "DataTables is a plug-in for the jQuery Javascript library. It is a highly flexible tool, build upon the foundations of progressive enhancement, that adds…
Popular Salesforce Videos
Things You Must Know About Salesforce Desk.com
Salesforce Desk.com is an all-in-one customer support application which is completely cloud based and which gives you the ability to buy services on per agent…
'Reduce Internal Email Clutter, Use Salesforce Chatter To Simplify Life' Webinar
Chances are, that as a Salesforce user, you aren’t using Chatter or aren’t aware of the power and value Chatter brings to team collaboration. Which…
Agile in Salesforce | Agile Salesforce Implementation
Watch this video to learn about Agile Salesforce Implementation When Salesforce met Agile Agile vs Waterfall Introduction to Scrum Scrum Roles Scrum Ceremonies Q&A
