-
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 Consulting Services: The Missing Piece in Puzzle for Users and Partners?
With the ever-increasing technology product portfolios and M&As of Salesforce, it can be challenging for most of the Salesforce partners to keep up with the…
Welkin's Customizable Path Brings your Salesforce Sales Path to a Completely New Level
We're extremely glad to introduce to you our new AppExchange product - Welkin's Customizable Path. Would you like to give your users better visibility of…
Personalization Boosting With The Special Features Of The New Salesforce Marketing Cloud
The research shows that more than 73% of customers would like companies to be aware of their particular expectations and requirements. In the last several years,…
Popular Salesforce Videos
Salesforce Integration Using Oracle SOA Suite
In this video, Bristlecone gives an introduction to Oracle Cloud Adapter for Salesforce.com. Afterwards, he goes into detail about how to integrate Salesforce.com using Oracle…
Adding an Email Service Channel with Email-to-Case | Salesforce Tutorial
Learn how to add an email service channel with Email-to-Case. This feature will enable you to resolve and correspond with customer inquiries via email without…
Insert Data in Salesforce Using Standard Controller
Standard controllers provides ability to access and interact with structured business data contained in records displays in the proper user interface. Standard controller tasks: controlling…
