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

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

Check Duplicate EmailId when user Insert the Contact

Check Duplicate EmailId when user Insert the Contact trigger OnContactChekDuplicateEmail on Contact (before insert) { Set<String> emails = new Set<String>(); List<Contact>lstCon = new List<Contact>(); set<String> setEmail = new set<String>(); for(Contact Con:trigger.new){ emails.add(con.Email); } lstCon=[Select name,id, email from Contact where Email in:emails]; for(Contact con :lstCon){  setEmail.add(con.email); } for(Contact c :trigger.new){  if(setEmail.contains(c.email)){   c.adderror('Email duplicate'); }    } }
Read more

Fetch Picklist value in LWC using Schema class

Image
 Create the Apex Class: public with sharing class lwcPicklistController {          //fetch picklist values from  SOBJECT     @AuraEnabled(cacheable=true)     public static List < customValueWrapper > pickListValueDynamically(sObject customObjInfo, string selectPicklistApi) {        Schema.DescribeSObjectResult objDescribe = customObjInfo.getSObjectType().getDescribe();             map < String, Schema.SObjectField > customFieldMap = objDescribe.fields.getMap();              list < Schema.PicklistEntry > custPickValues = customFieldMap.get(selectPicklistApi).getDescribe().getPickListValues();        list < customValueWrapper > customObjWrapper = new list < customValueWrapper > ();        for (Schema.PicklistEntry myCustPick: custPickValues) {         ...
Read more