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

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

Get Last day of Month

Get Last day of a month (28, 29, 30 or 31)? Formula DAY(ADDMONTHS(DATE(YEAR(DateField__c), MONTH(DateField__c),1),1)-1) The trick here is to take the 1st of the month and year of the date field, add 1 month to it and subtract 1 day. For example, if my date field is March 3rd 2022, the formula will add 1 month to March 1st 2022 and will return April 1st 2022. We then subtract 1 day to get March 31st 2022.
Read more

Write The Dynamic Query in Salesforce and bind in page block table with filter conditions

Class Code public class ClassName {     public product2 objProduct {get;set;}     public string StrCourseName {get;set;}     public string UserName {get;set;}     public id AccountId {get;set;}     public List<PricebookEntry> lstpbe ;     public List<WrapProductSelect> lstWrapProductSelect{get;set;}     public list<opportunity> lstOpportunityToInsert {get;set;}     public list<Offer_Item__c> lstofofferItem{get;set;}     public list<OpportunityLineItem> lstofOppLI;     public boolean isSelectedProduct;     public list<product2> lstProductSearched {get;set;}     public integer totalPageNumber{get;set;}     public integer intNumRecord{get;set;}     public Integer pageNumber{get;set;}     public Integer pageSize{get;set;}     public Integer intTotalCount{get;...
Read more