-
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
How to leverage NetSuite and Salesforce's Analytics Capabilities hand in hand?
NetSuite and Salesforce are today's most popular cloud-based business management software solutions. While each platform has its strengths and unique features, many businesses use both…
How to Convert sforce.apex.execute to Lightning | Salesforce Developer Guide
Introduction In this blog, we will learn how to directly call the apex class through a custom button or javascript button on the object detail…
Driving Innovation With Ideas From Your Online Community | Salesforce Guide
Innovation is the key to business growth. In order to come up with a successful product, you need to make the most of ideas and…
Popular Salesforce Videos
Salesforce Data Management - Data Loader - Insert, Update, Upsert, Export, Delete
Use the Data Loader wizards to add, modify, or delete records. The upsert wizard combines inserting and updating a record. If a record in your…
Salesforce CPQ from Scratch
CPQ Salesforce, or Configure, Price, Quote Software by Salesforce is a sales tool for companies to provide accurate pricing with any given product configuration scenario.…
Case Escalation In Salesforce | Salesforce Development Tutorial
Case Escalation in Salesforce. This video will cover the following points - 1. Case escalation Get a brief introduction about case escalation. 2. Configuration Take…
