-
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
Optimizing Insurance Operations with CRM Solutions
In the insurance industry, efficient management of customer relationships is crucial for business success. As customer demands grow and regulatory requirements become more stringent, leveraging…
Become an Advanced Salesforce Administrator [Exam Notes]
Have you ever doubted your skills of becoming an Advanced Salesforce Administrator? Most of us would have walked down that road, I’m sure. Whilst, some…
Enhanced Lookups In Salesforce
Records in custom lookup are searchable by Object Name or AutoNumber. What If we want to search the record for any other field value. Just…
Popular Salesforce Videos
Lightning Notifications Library | How and When to Use it in Salesforce? | Toast | Notice
In this video, you will learn about Lightning Notifications Library. We have two types of notifications available in it. 1. Toast 2. Notice In the…
Respecting Data Protection Laws on Salesforce
This video tells us all about data protection regulations and how to implement them on the Salesforce platform when designing custom solutions: - Introduction to…
The Rise of Salesforce
Salesforce is a cloud computing service as a software (SaaS) company that specializes in customer relationship management (CRM). Salesforce's services allow businesses to use cloud…
