-
Salesforce SOQL query for AccountContactRelation object
There is a standard junction object called AccountContactRelation which is seen when option for multiple accounts to single contact is enabled.
What query should be written to store the values in a Map?
I need the Contact id, Account id in a map. Or else, Contact id and the SObject.
Please help!
-
1 Reply
-
First allow "Allow users to relate a contact to multiple accounts" in setup --> account settings and then use below query to get the account and contact details.
select accountid,ContactId from AccountContactRelation
and use result as per your requirement.
Log In to reply.
Popular Salesforce Blogs
Easily Migrate to Lightning Knowledge from Classic Knowledge with This Strategy Guide
Your support reps can spend hours just juggling interfaces if your Service Cloud is in Lightning but Knowledge continues to be in Classic. This switching…
Salesforce Testing Essentials: Best Practices Simplified
What is a Test Class? A Test class is a set of Apex code written to validate the functionality of Salesforce components, such as classes…
Business Days in Salesforce CRM Analytics (Tableau CRM)
It's common for businesses to want to take business days into account when showing data on a dashboard in CRM Analytics (formerly Tableau CRM) to…
Popular Salesforce Videos
Salesforce Consultant Career | Salesforce Career Path | Salesforce Consultant Certification
If you're interested in becoming a Salesforce consultant, one of the first things to consider is how much education you need. We've determined that 60.2%…
7 Tips To Choose The Right CRM For Your Business
A Customer Relationship Management (CRM) system can be overwhelming to choose from. You have so many options to choose from, each offering different tools and…
What is Salesforce Commerce Cloud? | Salesforce Video Tutorial
Do you know what is Salesforce Commerce Cloud? Formerly called Demandware, it is a cloud-based service for unifying the way businesses engage with customers over…