-
I want to count related Contact in a Account.How can i do this in salesforce Apex Code?
I want to count related Contact in a Account.How can i do this in Apex Code?
-
2 Replies
-
Hi Suraj,
public class AccountProcessor {
static public Integer count;
@future public static void countContacts(Set<Id> AcctId ){
List<Account> Acclist=[select name,AccountNumber from Account where Id in:AcctId];
if(Acclist.size()>0){
for(Account A:Acclist){
count=0;
count=[select count() from Contact where AccountId=:A.Id];
A.Number_of_Contacts__c=count;//[select count() from Contact where AccountId=:A.Id];
update(A);
}
}where Number_of_Contacts__c is the custom Field on Account which store the Number of Related Contact in Account.
Hope this will Help You
-
Hi Suraj,
A much-optimized code would be -
Public static Map<Id,Integer> countRelatedContact( Set<Id> accId){
Map<Id,Integer> relatedCountMap = new Map<Id,Integer>();
if(!accId.isEmpty){for(Account acc : [select Id, name,(Select Id, Name from Contacts) from Account where Id in:accId];){
relatedCountMap.put(acc.Id,acc.Contacts.size());
}return relatedCountMap;
}This will return a Map of Account Id and # of related Contacts to that Account record. Hope this helps you as per your scenario.
Thanks,
Subhendu
Log In to reply.
Popular Salesforce Blogs
ViewAllCampaignMembers report for Salesforce Lightning
"Campaign call down" report in Salesforce Lightning The "Campaign call down" report doesn't seem to be working in the Salesforce Lightning Experience and so our…
Opportunity Line Items in Salesforce - Learn Here
What are Opportunity Line Items? The Products connected to an Opportunity are called OpportunityLineItem. There are many different things that a business might sell. These…
Debunking the Big 5 Myths about Salesforce Marketing Cloud
The Salesforce suite is a complicated platform. Your business, promoting, and client care groups can utilize it to make synchronized campaigns. It can follow your…
Popular Salesforce Videos
Salesforce Business Analyst Training
In the 35th Episode of the #AskTheHulk series, Savitha Asked about how to switch to IT from Non-IT background. To this question, Shrey suggested that…
Things You Should Know Before Starting Salesforce Consultancy?
Following are the things you should know before starting the Salesforce Consultancy: 1. Do the Marketing Research 2. Focus on USP The rest of the…
Creating Massive Junction Records with LWC | Salesforce Lightning Tutorial
Don't miss this new interchange session with Jorge Ortega and Alba Rivas! They'll discuss how to build an LWC that allows you to easily create…
