-
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
Sandbox Design for Enterprise-level Implementations!
Wondering how to create a separate environment for development? Looking for different configurations and use cases? Salesforce Sandboxes might be the answer… You might be…
Salesforce Applications: The New Trend to Follow
Salesforce is the current platform used by tech companies to stand out in the competitive market. Many companies- no matter big, medium, or small are…
Why Should You Prefer Salesforce Texting App Over Other Business Communication Channels?
In today’s cutthroat business landscape, organizations should not just focus on providing quality products and services but also maintain amiable customer relationships. However, this is…
Popular Salesforce Videos
New Product: RepBlaze on Salesforce AppExchange
Visit on AppExchange: Click Here As a Sales manager, if you deal with 1000’s of inbound and other leads everyday and would love to automate…
3 Must-Have Validation Rules in Salesforce to Save Time and Avoid Costly Mistakes
Validation rules in Salesforce act like quality checks for your data. They help make sure that the data in your Salesforce org is accurate and…
DreamTX Welcome Day 3: Customer Success | Dreamforce 2020 | Salesforce
If you missed DreamTX DAY 2, then live this amazing experience here, we have covered it all for you. Digital transformation requires more than just…
