-
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 are Scheduled-Triggered Flows in Salesforce?
Schedule-Triggered Flow (or Scheduled Flow) is a Salesforce Flow that launches automatically and repeats itself at certain intervals. For a batch of records, a schedule-triggered…
Questions to Ask Before Hiring the Services of a Salesforce Partner
To sustain in this era of cutthroat competition, maintaining superior customer relationships has become the need of the hour. This can be possible by providing…
Hello World Code for Salesforce Einstein
As a programmer, We do code in many languages. We create always a program named as Hello World. This blog is all about for Hello…
Popular Salesforce Videos
Introduction to SOQL in Salesforce
This video explains what is SOQL or Salesforce Object Query Language in Salesforce technology with examples from daily life for your better understanding .
Algoworks Is Now A Salesforce Summit (Platinum) Partner | Salesforce Consulting Services
It's been just a year since we became Salesforce gold consulting partners. Algoworks has now been recognized as a Salesforce Summit Partner (also known as…
Salesforce: Learn Workflow Rules in Just 10 min
Workflows in Salesforce are a fantastic way to automate certain business processes. You can create a rule, and based on certain criteria that you set,…
