Salesforce Query to Get the list of accounts where Related contacts Greater than 200 - Forcetalks

Tagged: Account List, Account List in Salesforce, Accounts in Salesforce, Contact List in Salesforce, Contact Object, Contact Record, Salesforce List, Salesforce Object Query Language, Salesforce Query

Salesforce® Discussions

Salesforce Query to Get the list of accounts where Related contacts Greater than 200

Posted by subramanyam subbu on January 31, 2018 at 3:40 PM

hi all,

Is it possible to write a query to get a list of accounts where associated contacts greater than 200?

Mohit replied 8 years, 3 months ago 2 Members · 1 Reply
1 Reply

Mohit

Member
February 1, 2018 at 9:38 AM

Hi Subramanyam Subbu,
Yes, it is possible to query the list of Accounts where Associated Contacts greater than 200.
For this, we can use the Aggregate query to fetch the AccountId of those Account record having related contact greater than 200.
Here is the Code below:-

AggregateResult[] groupedResults = [select AccountID from Contact GROUP BY AccountID HAVING count(AccountId)>200];

for (AggregateResult ar : groupedResults) {

System.debug(‘Account ID’ + ar.get(‘AccountID’));

}
Hope this may help you.

Thanks,
Mohit Agarwal

Log In to reply.