-
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
Fetching and Displaying Data in Salesforce Lightning Web Components: A Step-by-Step Guide Salesforce
Salesforce Lightning Web Components (LWC) is a framework provided by Salesforce to develop web applications easily. You know how to build cool things with building…
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…
Choose Salesforce Registered Partners for your Next Project
CRM platforms have emerged as a revolutionary tool for businesses to drive growth, improve customer satisfaction, and streamline operations. Salesforce leads the CRM industry with…
Popular Salesforce Videos
15 Things You Didn’t Know About Salesforce
In this video we'll try to answer the following questions: What is Salesforce and why it is used? What is the job of Salesforce developer?…
How to Find Queries that Target a Data Extension in Salesforce Marketing Cloud
In this video, Cameron Robert shows how to find SQL queries in Automations that affect a specified Data Extension in Salesforce Marketing Cloud. Key Moments:…
Happy 2021 to the Salesforce Ohana
As 2020 comes to a close, the challenges of the past year give way to hopes of a new year full of love, cheer, &…
