-
System.Query Exception: List has no rows for assignment to s-object?
System.Query Exception: List has no rows for assignment to s-object? How to resolve it?
-
3 Replies
-
Hi,
The exception is because of you are not getting any record in your SOQL query which meet the where criteria so it's give error. When attempting to fetch a single record from the database it is easy to run into the above exception. To avoid such exception use try-catch box like below :
MyObject__c obj;
try{
obj = [SELECT id FROM MyObject__c WHERE name=:previouslyDefinedVar];
} catch(System.QueryException e){
// Perform logic here
}
Hope this helps!
-
Hi
It means your SOQL didn't return any results. You can wrap it in a try/catch statement to handle this gracefully.
This error occurs when query doesn't return any rows.
For e.g.:- Account a = [select id, name from Account where name = 'test'];
Instead of using this we should use like that:-
List<Account> lstAccount = [select id, name from Account where name = 'test'];
if (lstAccount.size() > 0)
{
Account a = lstAccount.get(0);
}Thanks
-
Hello Prachi,
Well, this type of error shown when your SOQL didn't return any results. You can wrap it in a try/catch statement to handle this gracefully.
For more information, kindly share your code.
Thanks.
Log In to reply.
Popular Salesforce Blogs
Introduction to Salesforce Conga Composer
The growing demand of making everything digital and prior focus to make documents created and verified on the internet only, It is important to build…
TriggerFactory in Salesforce Apex | The Developer Guide
Trigger structures in Apex are something clever. We as a whole realize we need them, we as a whole realize that it is best practice…
Common Mistakes while Performing Salesforce Integration: What not to do
Integration means combining two different systems, portals, applications, etc with each other in order to make them as one application. Integration is very widely implemented…
Popular Salesforce Videos
Product Rule Vs Price Rule Salesforce CPQ
Product Rule CPQ product rules help ensure sales reps are putting together the right products and bundles every single time. You don’t have to worry…
How to Find out Who Deleted a Record in Salesforce
Salesforce administrators can determine who deleted a record by looking at the Recycle Bin or querying for deleted records via API. Watch this video and…
How can Salesforce Field Service Help in Providing a Better Customer Experience?
Salesforce Field Service Management automates and optimizes the work of field service workers (agents, dispatchers, mobile technicians). It is part of the Service Cloud and…
