-
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
Salesforce Hacks for a Successful Admin/Developer
1.) Salesforce Merge more than 3 Accounts at Once. With the Merge Accounts page provided by official SFDC selection screen, a user can only Merge at most of…
Redefining the future of Marketing – Salesforce Marketing Cloud Integration with Google Analytics 360
Know your customers better and make smarter, insight-based marketing decisions through Salesforce’s massive customer relationship management platform twinned with Google Analytics 360’s market-leading digital analytics solution…
MuleSoft's New AsyncAPI Support Enhances AI-Powered Customer Interactions
MuleSoft has launched an open beta for AsyncAPI support in its Anypoint Platform to facilitate the adoption of event-driven architectures (EDAs). This feature enables businesses…
Popular Salesforce Videos
Build Your First Custom App On Salesforce
Lightning App Builder makes it super simple to quickly assemble apps using just declarative drag and drop features. This video covers how to upgrade a…
Salesforce CPQ Bundles - Why You Need Them and How to Create a Bundle
Salesforce CPQ stands for Configure, Price, and Quote. This tool simplifies the whole process of configuring product bundles, pricing them, and generating quotes for customers.…
Run UI Tests with UTAM | Salesforce Developer Tutorial
Testing apps is critical to ensure quality and there are different types of tests such as unit tests, integrations tests or end-to-end tests just to…
