-
SOQL Query ( Accounts and Contacts ) in Salesforce
Dear Sir / Mam,
I have one question :-Write an SOQL Query in Developer Console where I want to Display Accounts and their Corresponding Contacts ( First Name, Last Name etc ) BUT only those Accounts who have more than ONE Contact.
Thanks
RegardsRahul
# 9958495609
-
2 Replies
-
Hello Rahul,
#Apex Class
public class AccountAndContacts {
public static void displayContacts(){
List<Account> acc=[Select Id,Name from Account];
for(Account a:acc){
List<Contact> con=[Select LastName from contact where AccountId=:a.id];
for(Contact c:con){
if(con.size()>1){
System.debug('AccountName '+''+a.Name+'RelatedContacts '+''+c.LastName);
}}}}}#Anonymous Window
AccountAndContacts.displayContacts();
#Check the output in debugger log...
Hope it will help you.
Note:I have written it in simple understandable ,way you can optimize code by using nested query.
- [adinserter block='9']
-
Hello Rahul ,
you can try this :
public class SearchCont {
public static List<Account> acct;
public static List<AggregateResult> aggRes;
public static void contSearch(){
List<String> ide=new List<String>();
aggRes =[select accountId,count(id) from contact where account.name !=null group by accountId having count(id) >1];
for (AggregateResult ar : aggRes) {
ide.add((String)ar.get('accountId'));
}
acct=[select name,(select LastName,FirstName from contacts) from account where id in :ide ];
for(account acc: acct){
system.debug('###'+acc);
for(contact con: acc.contacts){
system.debug('###'+con.LastName);
system.debug('###'+con.FirstName);}
}
}
}
Log In to reply.
Popular Salesforce Blogs
6 Easy Ways You Can Turn Implementing Salesforce CRM Into Success
Salesforce CRM, if executed properly can deliver phenomenal perks like improved customer satisfaction and high yielding lead generation and slashing operating costs. Good sales team…
TriggerFactory in Salesforce Apex | The Developer Guide
Trigger structures in Apex are something clever. We as a whole realize we need them, we as a whole realize that it is best practice…
Salesforce Public Cloud for Education
Digitalization has transformed the way we live and has made data effortlessly accessible in a world that is always on the go, and it has…
Popular Salesforce Videos
5 Reasons To Choose Marketing Automation For Your Business | Salesforce
With the advancement in technology, it has become imperative to move towards more advanced methods to grow your business. Marketing automation is one method that…
How to Find More Prospects, Win More Deals, and Keep Customer Happy with Salesforce Essentials
Watch this video to learn how to minimize busy work and empower your sales and support teams to spend more time closing deals and engaging…
Generate the Multiple Contracts in Salesforce CPQ
In this video, watch a demonstration of how to generate multiple contracts using a single quote record. Watch and learn. Do let us know in…
