-
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
Einstein Discovery in 2024 | CRM Analytics
The Einstein Discovery model (CRM Analytics model is the same if we come across such a name) is a set of tools and data that…
Sharing Settings in Salesforce | The Ultimate Guide
Salesforce is a powerful Customer Relationship Management (CRM) platform that offers a wide range of features and functionalities to its users. One of the most…
The What, Why, and How of Salesforce Change Management
If you are introducing new features or processes to a Salesforce instance, then you might make or break the system. In the contemporary business environment,…
Popular Salesforce Videos
Salesforce Einstein – CRM Stepping Into The World Of AI
We belong to a hyper-connected world these days where each and every step we take is an onslaught of data. So for this world what…
Benefits of Implementing Salesforce Revenue Cloud
Healthy revenue growth is a vital indicator of a firm’s success. The key aspects that majorly affect an organization’s revenue growth are sales, operations, finance,…
How Admins Can Improve Salesforce Data Quality
Learn how to diagnose the accuracy of your data and build a plan to maintain and enhance its’ quality using Salesforce tools. Follow along to…
