How to Select All Fields with SOQL in Apex

How to Select All Fields with SOQL in Apex

// Based on Record ID , fetch all the field particular object

ID recordId = '01t90000000vQFw';
DescribeSObjectResult describeResult = recordId.getSObjectType().getDescribe();
List<String> fieldNames = new List<String>( describeResult.fields.getMap().keySet() );
System.debug( fieldNames);
String query = ' SELECT ' + String.join( fieldNames, ',' ) +' FROM ' + describeResult.getName() +' WHERE ' +
    ' id = :recordId ' + ' LIMIT 1 ';
   
   // return generic list of sobjects or typecast to expected type
List<SObject> records = Database.query( query );
System.debug( records );


// Based on Object without an ID, simply specify the object to then derive the sobject type
    DescribeSObjectResult describeResult = SobjectApiName.getSObjectType().getDescribe();
List<String> fieldNames = new List<String>( describeResult.fields.getMap().keySet() );
System.debug(fieldNames);
String query = ' SELECT ' + String.join( fieldNames, ',' ) +' FROM ' + describeResult.getName();
// to return generic list of sobjects or typecast to expected type
List<SObject> records = Database.query( query );
System.debug( records );
System.debug( records.size());

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