-
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
Learn All About Process Builder in Salesforce and Its Features
Would you like to make a record for any item from a work process? Would you like to call your Apex class from a work…
Alert Triggers in Twilio!
What are Alert Triggers? Alert Triggers are nothing but alerts via webhook or mail you when number of error events cross the Trigger Value on…
Hire the Best Salesforce Implementation Partners in USA
Scaling a business in today’s digital landscape requires more than just a CRM; it requires a powerhouse ecosystem that aligns your sales, marketing, and service…
Popular Salesforce Videos
What are lookup filters in Salesforce?
In this video, we will leaarn about Lookup Filters in Salesforce by dividing this topic into 4 basic points, which are: 1. What is a…
Marketing Cloud | Salesforce Send Email
There are two ways to send an email in Marketing Cloud; Guided Send Wizard & Salesforce Send Email. The benefit of the Salesforce Send Email…
Configuration Attribute In Salesforce CPQ | Salesforce Development Tutorial | Learn Salesforce Series by Algoworks
Configuration attributes can be used in setting up the value of multiple shared product option fields simultaneously in Salesforce CPQ. In this Salesforce tutorial, you…
