-
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
Mastering Email Deliverability in Salesforce Marketing Cloud
In today’s world of digital marketing, an email's journey from your campaign to your subscriber's inbox is an important aspect that has a bearing on…
4 Top Features of Salesforce Partner Portal To Increase Business Revenue
Salesforce partner portal enables your business partner who isn’t a part of your organization to log in to your Salesforce account easily. It will help…
Is Your Healthcare System Stuck in the Past? Meet Salesforce Health Cloud!
Imagine this: You’re visiting your doctor for a routine check-up. You wait forever to get in, then explain your medical history for the umpteenth time…
Popular Salesforce Videos
AMPscript Lookup - Salesforce Marketing Cloud Functions in 5 minutes
Salesforce Marketing Cloud functions in 5 minutes! In this video, Cameron Robert shows how Lookup() works in Salesforce Marketing Cloud using some helpful visuals to…
How Admins Can Improve Salesforce Data Quality
Learn how to diagnose the accuracy of your data and build a plan to maintain and enhance its’ quality using Salesforce tools. Follow along to…
Accenture Salesforce Training 2022
This video is about -Accenture Salesforce Training 2022 Orientation session and ASE SFDC Salesforce Certification. As the trusted leader in Salesforce implementation and transformation, Accenture can…
