-
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
Multi-Factor Authentication in Salesforce - The Brief Guide
Cybercrimes, phishing attacks, Security breaches etc. are the terms that are known by everyone nowadays. Security has become a major issue and the reason behind…
Salesforce Slack Integration and Configuration: Our Tried and Trusted Approaches
Both Salesforce and Slack are powerful business technologies on their own. Salesforce is the global No. 1 CRM, integration, and analytics platform. Slack is the…
How the Salesforce1 Mobile App Can Help Businesses
To understand “how the Salesforce1 mobile app can help the business”, we must first understand the how and the difference between Salesforce and Salesforce1. The…
Popular Salesforce Videos
Salesforce Lightning Training
Here, the video is about the Salesforce Lightning Tutorial. These video covers comprise real-world projects that will introduce you to advanced concepts such as Lightning…
Top 5 Marketing Tips to Reach Millennials | Salesforce Guide
The word “millennials” has become a buzzword in recent years Millennials or members of Generation Y (also known as Gen Y) were born between 1982…
Salesforce Training for Beginners | Salesforce Tutorial for Certification
Once upon a time, storage was a big problem, but the innovations in technology have solved this. We can say that Cloud computing is one…
