-
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.
-
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
Avoiding Race Conditions
An action function provides a way to submit a form programmatically via a JavaScript function call. When an action function is executed from a JavaScript event…
When to use REST & When to use SOAP ?
Most of the sfdc beginners came across this question "When should I use REST & When to use SOAP API" , but not all of…
How Slack and Sales Cloud Can Help You Close More Deals in 2023?
Companies strive to increase sales productivity in a challenging economic climate while simultaneously cutting expenses. Sales teams are searching for methods to attain these objectives.…
Popular Salesforce Videos
Salesforce Full Course - Learn Salesforce in 9 Hours | Salesforce Training Video
Salesforce Full Course video will help you understand and learn Salesforce Cloud services in detail. This Salesforce Tutorial is ideal for both beginners as well…
Salesforce Nonprofit Cloud Implementation Guide
While Salesforce offers a variety of tools that can help a nonprofit organization, the latest and greatest of these is Salesforce Nonprofit Cloud. Nonprofit Cloud…
How To Send Email Using Apex | Apex Salesforce Tutorial
This tutorial will show how you can send emails using Apex. The following points will be covered - 1. Introduction Take a look at the…
