-
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
How You Can Boost Online Grocery Sales? | Salesforce Help Guide
COVID-19 has accelerated the shift to eCommerce and it is more evident than in the grocery category. Online grocery buyers have increased nearly 30 percent…
Salesforce B2B Commerce Cloud for Modern Businesses
In the fast-paced world of digital commerce, businesses are constantly seeking innovative solutions to enhance their online presence and streamline their operations. Salesforce B2B Commerce…
Salesforce Dynamic Forms: Overview, Benefits, Business Cases
On a user page layout in Salesforce might be placed a monolit block of fields which makes customization impossible. The task of Dynamic Forms is…
Popular Salesforce Videos
Know Why Salesforce Is Secure For Your Business Data
Salesforce.com uses a variety of methods as mentioned in the video - to ensure that your business data is safe, secure, and available only to…
Salesforce lightning customize record page: Build a Custom Record Page
Salesforce Lightning Experience comes with a slick user interface that is easy to navigate and even easier to use right from the beginning. Lightning is…
Mastering the VLookUp Function | Salesforce Tutorial
Watch this amazing video tutorial and follow these steps to effectively use the VLookUp function for data import purposes in your Salesforce database. If you…
