How to count the number of child records under a parent using Apex

Mike Arthur • 16 August 2017

No need for any counter, use a Set and an Aggregate query

No content of my own here, just a pointer to someone who really knows what he's talking about, Peter_sfdc, the mighty Peter Chittum, check out his reply here:
https://developer.salesforce.com/forums/?id=906F0000000AcdaIAC

(Of course, if you don't have a good reason to use Apex, you can always go with Flow, as explained by the equally mighty Mike Gill:
http://www.salesforceweek.ly/2015/02/how-to-create-roll-up-summaries-using-flow.html
http://www.salesforceweek.ly/2015/02/how-to-create-roll-up-summaries-using-flow-part-2.html)

My Blog of Salesforce Stuff

by Mike Arthur • 16 October 2021
'XHR Failed' error when trying to install VS Code extension
by Mike Arthur • 9 June 2020
What is $A (dollar A) in Lightning Aura component framework? Is it a global variable? Where are the docs for $A?
by Mike Arthur • 8 May 2020
Authorise a Salesforce Connected App using OAuth 2.0 JWT Bearer Flow
by Mike Arthur • 26 April 2020
REST API Connection to Salesforce Connected App Using OAuth 2.0 Authentication from Postman
by Mike Arthur • 23 March 2020
How to create a Lightning tab menu with dropdown sub-menu
by Mike Arthur • 27 November 2018
How to show a month by month trend chart with multiple years on same chart
by Mike Arthur • 6 November 2018
What to do if you receive emails about expiring certificates
22 August 2018
Process json strings when working with integrations
by Mike Arthur • 22 August 2018
If you're switching email accounts you can copy appointments from one calendar to the other
by Mike Arthur • 22 August 2018
When you search in Outlook 2016, how do you see in which folder you filed an email in the results?
More posts