Fetch All Account in SOQL without any Contacts.

Fetch All Account in SOQL without any Contacts.

 List<Account> lst=[SELECT Id 
                   from Account where ID NOT IN
                   (Select AccountID from Contact) limit 1];

 system.debug('lst****'+lst);

Comments

Post a Comment

Popular Post

Send SMS Using Batch Class in Salesforce

Que:  Integrate SMS Functionality in salesforce using batch Class Requirement: Send Sms to user if user has birthday today. Solution: Fristly Create a batch class and schedule this class every day //Note: you need to create Custom Setting for Username password sender id and etc //and also Add Url in Remote Site Setting global class ClassName implements Database.Batchable<Sobject>,Database.AllowsCallouts {     List<Contact> lstofContactBirthdate = new List<Contact>();          static CustomSettingName__c objCS = CustomSettingName__c.getOrgDefaults();// Custom setting     List<string> lstofSMSString;     //Get date and Month from Today Date      Date currentdate = system.Today();     Integer TodayDay = currentdate.Day();     Integer TodayMonth = currentdate.month();     String CurrentDayandMonth = TodayDay+'/'+TodayMonth; ...
Read more

Create Custom Lookup in salesforce

Image
Requirement : Create a custom Lookup Solution : you need to create two visual force page Create first VF Page and Class Page Code <apex:page controller="LookupMainControllerForFilter" tabstyle="Account"> <script>     var newWin=null;     function openLookupPopup(name, id)     {         var url="/apex/LookupExamplePopup?namefield=" + name + "&idfield=" + id;         newWin=window.open(url, 'Popup','height=500,width=600,left=100,top=100,resizable=no,scrollbars=yes,toolbar=no,status=no');         if (window.focus)          {             newWin.focus();         }                      return false;     }                        function closeLookupPopup()   ...
Read more

Roll Up Amount on Parent Object from Child Object In Lookup Relationship

Requirement : Write a Trigger to roll up amount from Student object to Teacher Object   Teacher as parent object and Student as a Child Object Solution : trigger RollUpAmountonTeacher on Student__c (after delete, after insert, after update)  {     set<id> setTeacherID = new set<id>();          List<Teacher__c> lstTeacherToUpdate = new List<Teacher__c>();          if(trigger.isAfter)     {         if(trigger.isDelete)         {             for(Student__c objStu : trigger.old)             {                 setTeacherID.add(objStu.Teacher__c);             }         }         else         {             for(Stu...
Read more