Home SALESFORCEAPEX SObject row was retrieved via SOQL without querying the requested field in Salesforce

SObject row was retrieved via SOQL without querying the requested field in Salesforce

Error:
SObject row was retrieved via SOQL without querying the requested field: Contact.Name.

Solution:
If we used Name field in your coding without querying in your SOQL, then we will get the above Error.
ContactId = ‘003L0000008au4P’;
Contact fetchContact = [Select Id, AccountId from Contact Where Id:= ContactId limit 1];

//if we updating the Name Value without fetching the above SOQL, then error should be throw
fetchContact.Name = ‘TheBlogReaders.com’;

So best practise is add the Name value in the above SOQL query:
Contact fetchContact = [Select Id, AccountId, Name from Contact Where Id:= ContactId limit 1];

You may also like

Leave a Comment