Thou shalt not put queries in loops (good example)
List<Account> accList = new List<Account>( | |
[Select | |
Id | |
,Name | |
,(Select | |
From | |
Contacts | |
) | |
From Account] | |
); | |
for(Account acc : accList){ | |
Integer numWithEmail = 0; | |
for(Contact cont : acc.Contacts){ | |
if(!String.isEmpty(cont.Email)){ | |
numWithEmail++; | |
} | |
} | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment