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

Show Hyper Link On Add Error in Salesforce Trigger

Requirement: Check Duplicate record in system and show the add error in form of hyperlink corresponding duplicate record ID Solution : Write a trigger and show add error objExistingRecord >>> OldRecord Id objNewRecord >> New Record  objNewRecord.addError('Same Combination of Record already Inserted in System: <a href=\'/'+ objExistingRecord.id +'\'>'+objExistingRecord.Name+'</a>', false);                                                                           Thanks                                                Sumit Shukla
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

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