-
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
- [adinserter block='9']
-
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
Salesforce Consultant: The Complete 2026 Guide to Hiring, Costs & Implementation Success for USA Businesses
The Problem Nobody Talks About (But Every Sales Manager Experiences) It's Monday at 9 AM. Your VP of Sales opens Salesforce and realizes the forecast…
Providing Advisors with Insights on Offerings using Salesforce
Advisors need access to timely, relevant, and actionable insights required in the financial services sector to provide their clients with a differentiated experience, but also…
Empower Your Business with Expert Power BI Developers and Consultants
In today's data-driven world, organizations need actionable insights to make informed decisions. Hiring a skilled Power BI developer or Power BI consultant can unlock the…
Popular Salesforce Videos
Salesforce Pay Expectations $$$ US and UK
Do you agree or disagree with these numbers? How do you think Mason Frank could have surveyed differently? In this video, Brad discusses just how…
Apex Triggers in Salesforce | Concepts and Examples
Apex triggers enable you to perform custom actions before or after changes to Salesforce records, such as insertions, updates, or deletions. A trigger is Apex…
Security Best Practices for Building Lightning Components
Lightning Component is a framework to build Salesforce applications faster. If you are using Salesforce1, you already experiencing the Lightning. It is based on an…
