-
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
Automation studio in Marketing cloud
Automation Studio - Automation Studio makes Marketing Cloud email sends, queries, imports, and more happen automatically. Automation Studio is a Salesforce Marketing Cloud application used…
Attending NorCal Dreamin’ 2019? Stop By Algoworks At Booth No. 14!
Algoworks is going to Sacramento this June to pal around with the members of the Salesforce family. The Salesforce community is gathering for NorCal Dreamin’…
Boost productivity with the Salesforce Inspector Chrome Extension
With digitization, the workload in every organization is growing exponentially, creating a lot of mundane, but essential tasks. These activities are time-consuming and not so…
Popular Salesforce Videos
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…
7 Tips To Choose The Right CRM For Your Business
A Customer Relationship Management (CRM) system can be overwhelming to choose from. You have so many options to choose from, each offering different tools and…
How to use Cauzali in Salesforce Service/sales cloud and all of Salesforce industry clouds. Add functionality to your users with Cauzali
With a maximum price of $6.000 a year for your org. You and your colleague can make all the solutions you want including Community solutions.…
