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

Update Record on Custom Button Using JavaScript on Detail Page

{!REQUIRESCRIPT("/soap/ajax/19.0/connection.js")}  var DayPlanRecord = new sforce.SObject("Object Name");  DayPlanRecord.id = "{!ObjectName.Id}";  DayPlanRecord.FieldName = false ;  var recordType = sforce.connection.query("Select ID,FieldName, Name From ObjectName where FieldName = false " );  DayPlanRecord.FieldName = true ; result = sforce.connection.update([DayPlanRecord]);  window.location.reload();
Read more

Select and Deselect Check Box on Page Block Table in Visual force Using JavaScript

Image
Requirement: Using javascript select all and Deselect all checkbox in pageBlock Table Solution <apex:page sidebar="false" Controller="ManageOppController">     <script>         function selectAllCheckboxes(obj,receivedInputID){             var inputCheckBox = document.getElementsByTagName("input");                               for(var i=0; i<inputCheckBox.length; i++){                           if(inputCheckBox[i].id.indexOf(receivedInputID)!=-1){                                                          inputCheckBox[i].checked = obj.checked;                 }     ...
Read more