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

Salesforce Spring 16 Release Exam (Maintenance Exam Q&A) for Developer 201 Admin

Spring 16 Salesforce Admin 201 Maintenance Exam 1. Which areas are calculated for the Health Check score? Choose 2 answers A. Number of users B. Session Settings  C. Profiles and Permissions assigned D. Password Policy E. Login attempts 2. What key user access data is included in login forensics? A. Who logged in from a new browser more than once in a day. B. Who logged in more than the number set in the profile. C. Who logged in during business hours. D. Who logged in more than the average number of times. 3. What is true regarding the new Data Loader? A. It has a new column flagging duplicate files. B. It supports Web Server OAuth Authentication for Windows or Mac. C. It has downloadable add-ons published through the AppExchange. D. It works with all legacy security protocol. 4. What does the Customize Application permission setting allow? A. To create article types. B. To edit contract settings. C. To modify custom picklist values. D. To create a...
Read more

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

Show Custom And Standard Object

Image
ShowCustomAndStandardObject Requirement:   Create two custom pick list field . first picklist contains the the three values" All, Custom, Standard" when user select "All" then in the second picklist show all custom and standard object, and when user select "custom" the custom object filter and same for  "standard". And After that click on "show filed" button  then all field of selected object appear in table. and User can select the fields and click on "query button" the generate query in string form. <!--ShowCustomAndStandardObject--> Create Visualforce page <apex:page controller="clsCustStandObj"> <meta name="google-translate-customization" content="afb3859aeab26f11-8390680e6d2f19bf-g71f10bf08db6379c-15"></meta> <div id="google_translate_element"></div><script type="text/javascript"> function googleTranslateElementInit() ...
Read more