-
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
CRM+Marketing Automation: A Powerful Solution to Grow your Business
Customer relationship management(CRM) helps business owners track and manage their customer base. CRM software is ideal for making the most of relationship development with existing…
How to setup an Einstein Chatbot in Salesforce?
In this article, we will discuss Einstein Chatbot and consider Omni-Channel, Lightning Knowledge Base, Embedded Service Deployment, and more. The first point to note: this…
Email Templates in Salesforce Classic and How To Send Them For a Particular Record
Email Templates are designed for consistent mails so as to increase productivity. Before we discuss further about Email Templates, let us know about the required…
Popular Salesforce Videos
Send WhatsApp Messages from Salesforce Marketing Cloud
One of the longest-anticipated integrations was recently revealed by Salesforce: WhatsApp as a platform to send messages using the marketing cloud. Brands today have many…
Salesforce Connect ( Cross-Org Adaptor ) | Salesforce Tutorial
This video will talk about external objects using Salesforce Connect, also known as Cross-Org Adaptor. 00:00 Introduction 00:29 Introduction to Cross Org Adapter 01:51 Create…
What are Custom Page Layout in Salesforce?
Custom Page Layout is creating its own layout and modifying the same layout which we have created. Watch this video to learn all about Custom…
