-
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
Integrating and Automating B2B Sales Workflows with Custom Salesforce Integrations
When you think about the complex world of B2B sales, it’s clear that there are a lot of moving parts. Sales teams juggle multiple tasks—from…
4 Phases of Salesforce Classic to Lightning Migration
Salesforce Classic to Lightning Migration offers you access to better UI, new features, and more opportunities to scale. When Salesforce Lightning was launched in 2015,…
Know How To Display Parent Fields Value On A Standard Lightning Data Table
As we all know lightning data table has a limitation in directly displaying parent fields value related to the child object. However, we have a…
Popular Salesforce Videos
Salesforce Data Archive along with Files
This video tries to explain the way true archive of records as well as the files in Salesforce. Archive files along with the DataArchiva, We…
5 Benefits of Integrating Mulesoft Into Your Business | Salesforce Integration
The MuleSoft integration solution has provided visionaries throughout the world with the power to connect all their data, systems, and devices seamlessly. Swipe to know…
Salesforce Integration Cloud - Connect Devices, Data and Customers
Salesforce Integration Cloud incorporates an arrangement of services and tools that make it simple for clients to surface their information paying little attention to where…