-
Fetch account details using "AccountContactRelation" junction 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,
It will be a two-step process. First, you need to fetch all contact ids which has more than one contact.In the second step, you can retrieve Account information.
set<Id> setOfContactIds = new set<id>();
for(Contact conObj : [select id, (select id from AccountContactRelations where isDirect = false) from contact]){
if(conObj.AccountContactRelations.size()>0){
setOfContactIds.add(conObj.id);
}
}
system.debug(‘::’+[select id, Account.name from AccountContactRelation where ContactId IN:setOfContactIds]);
Log In to reply.
