list has no rows for assignment to sobject salesforce apex

• Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers
• Advertising & Talent Reach devs & technologists worldwide about your product, service or employer brand
• OverflowAI GenAI features for Teams
• OverflowAPI Train & fine-tune LLMs
• Labs The future of collective knowledge sharing
• About the company Visit the blog

Collectives™ on Stack Overflow

Find centralized, trusted content and collaborate around the technologies you use most.

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

Get early access and see previews of new features.

System.QueryException: List has no rows for assignment to SObject

I want update list of opportunities using visualforce page.In visualforce page I want to update Amount,close date and Stage.The visulaforce page should only show all open opportunities(STAGE NOT EQUALS TO CLOSED WON AND CLOSED LOST).

Anyone help me to fix this error and update only all open opportunities.

Here is my code:

Error shown in this line:

• visualforce

I suspect your id parameter is not passed through so it's a null. Querying Opportunities WHERE Id = null will always return zero results. Or maybe it's being passed but it's useless. If you have StandardSetController the Id value in the page URL might be used as filter id (listview), not an id of any particular record. Meaning query will still return 0 rows.

What were you trying to do? Maybe just removing that part of condition will help although this list can grow very fast. You might want to put a LIMIT statement in the query or read about StandardSetController and pagination.

Your Answer

Reminder: Answers generated by artificial intelligence tools are not allowed on Stack Overflow. Learn more

Sign up or log in

Post as a guest.

Required, but never shown

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy .

Not the answer you're looking for? Browse other questions tagged apex visualforce or ask your own question .

• The Overflow Blog
• Scaling systems to manage all the metadata ABOUT the data
• Navigating cities of code with Norris Numbers
• Featured on Meta
• We've made changes to our Terms of Service & Privacy Policy - July 2024
• Bringing clarity to status tag usage on meta sites
• Tag hover experiment wrap-up and next steps

Hot Network Questions

• Why is "a black belt in Judo" a metonym?
• Examples of flat projective morphisms with non-divisorial branch locus
• What are those bars in subway train or bus called?
• What counts as a pet?
• Am I allowed to link code licensed under GPL to proprietary libraries?
• A post-apocalyptic short story where very sick people from our future save people in our timeline that would be killed in plane crashes
• How can sound travel as a transverse wave?
• "Not many can say that is there."
• Dropper post won't actuate. Is this fixable?
• Are there rules of when there is linking-sound compound words?
• 3D cartoon involving a lion with a crown on his head, a crystal, and artifacts that need to be found
• Justification for the Moral Ought
• Getting straight single quotes in a bibliography
• Why does editing '/etc/shells' file using 'sudo open' show an error saying I don't own the file?
• Is "the above table" more acceptable than "the below table", and if so, why?
• What is the lowest feasible depth for lightly-armed military submarines designed around the 1950s-60s?
• Why did evolution fail to protect humans against sun?
• Transit from intl to domestic in Zurich on Swiss
• Can you continue a database log restore after putting an interim restore online?
• Why are these simple equations so slow to `Solve`?
• Automotive Controller LDO Failures
• What tool has a ring on the end of a threaded handle shaft?
• can a CPU once removed retain information that poses a security concern?
• What are these on my cabbages?

Salesforce – List has no rows for assignment to SObject

if you using following code in Apex and Error should throw like “List has no rows for assignment to SObject”.

Account a = [Select name from acoount where id =: strId];

Try to avoid the error following code in you Apex.

List<Account> lstAccount = [Select Id, name from acoount where id =: strId];

Sakthivel Madesh

3x Salesforce MVP | Platform Champion | 22x Salesforce Certified | MuleSoft Certified | All Star Ranger | TechForce Services | Sydney | Australia

What are the Granting Access available in Salesforce Event Calendar

How to return a pagereference to create a sobject in salesforce, you may also like, upgrading apex classes for custom metadata access: a..., congratulations to the 2024 class of salesforce mvps,..., unlock your salesforce certification with free vouchers in..., free salesforce certification days webinars – december 2023, spring 24 – dynamic forms supported the related..., salesforce flow – repeater (beta) screen components –..., salesforce flows & reactive screen components: the next..., free salesforce certification days webinars – november 2023, join the salesforce community sprint: accelerating innovation together, elevate your salesforce journey with free accredited professional..., leave a comment cancel reply.

Save my name, email, and website in this browser for the next time I comment.

SFDC Stop - Always the latest about Salesforce

Full tutorial series with videos, free apps, live sessions, salesforce consulting and much more..

• _Platform Event Toast
• _HTTP Callout Framework
• _SFDX Deploy Tool
• _SObject Convertor
• Live Sessions
• _TDX18GG - Salesforce UI API
• _TDX18GG - Lightning Testing Service
• _DF17GG - Lightning Data Service
• Tutorial Series
• _JavaScript Tutorial Series
• _Salesforce LWC Tutorial Series | ToDo App Project
• _Salesforce Integration Tutorial Series
• _Salesforce Lightning Events Tutorial Series
• _Salesforce Lightning Tutorial Series
• Discussions
• _Salesforce Development
• _Ideas for upcoming posts
• Become an Author

Monday 22 January 2024

Solution for "system.queryexception: list has no rows for assignment to sobject" - null coalescing operator () | spring'24 release.

Points to remember about Null Coalescing Operator

About Rahul Malhotra Rahul Malhotra is currently working as an Application Engineer at Google . He has delivered various live technical sessions at International and National Salesforce Conferences including TrailheaDX India 2019, Dreamforce 2018, IndiaDreamin 2018, Jaipur Developer Fest 2018 as well as other global gatherings of Salesforce. Connect with him on Connections App . Username: rahulmalhotra

No comments:

Post a comment, mastering lightning datatable in salesforce lwc.

Learn how to implement lightning datatable in LWC from scratch. Implement all features from basic to advanced level.

Recognized by Apex Hours as Top Salesforce Blog

$50 OFF with LIFETIME ACCESS. Complete Salesforce Platform & Lightning Experience Training Pack

LWC Training

Competitive Programming Solutions

Subscribe for free tutorials

• @rahulcoder

Feed Subscribe

Featured post

Sfdx deploy tool - easily deploy metadata using sfdx cli.

Report Abuse

Blog archive.

• Affiliate Disclaimer
• Privacy Policy
• Contribute to SFDC Stop | Become an Author
• What do you want to see next on SFDC Stop ?

Total Pageviews

Recent comments.

Stack Exchange Network

Stack Exchange network consists of 183 Q&A communities including Stack Overflow , the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

I'm getting "List has no rows for assignment to SObject" error on a Visualforce component

EDIT: Is there a recommended way for a VF email template that uses a VF component to display in the SFDC UI such that you don't get the error message "Error occurred trying to load the template for preview: List has no rows for assignment to SObject. Please try editing your markup to correct the problem"

when saving the template? As the original problem description states below, I get this message when saving the VF template. The only workaround (see component controller code) that seems to work for me is to read a "test" opportunity such that the VF template has something to display, but this seems to be a complete hack - and I'm not guaranteed to have a "test" opportunity in any environment.

ORIGINAL: I'm trying to use a component in a VF email template that queries opportunity line items from an opportunity lookup in a custom object. I get the error "List has no rows for assignment to SObject" if I don't query at least one opportunity object, which is the basis of my question.

The gist of the VF template is this;

The Component looks like this;

And the controller is this;

But what I don't like is I'm burning an extra SOQL statement just for preview of the VF page. If strOptID is null (during preview) I have to query an "artificial" opportunity that "should" be there ("%Test%").....

I don't like this solution and I'm sure there's a better way, and I was hoping someone might point me to a more appropriate way to accomplish this.

Thanks in advance.

• visualforce
• visualforce-component

• 1 possible duplicate of Help with error: List has no rows for assignment to SObject –  Daniel Ballinger Commented Mar 2, 2015 at 18:31
• 4 I've voted to close this question as the general error has been covered previously in other questions. As a general rule, don't assign the results of a SOQL query to a singular sObject. If the query doesn't return any rows you will get the "List has no rows for assignment to SObject" exception. Instead, assign the results to a list of sObjects and check the size of the list. Then only use the first record in the list if it is present. –  Daniel Ballinger Commented Mar 2, 2015 at 18:33
• Hi all, that link doesn't cover components - I vote that it's a different problem. I've searched "VF Component" and "No Rows" and this is the only question. –  user2223 Commented Mar 2, 2015 at 18:37
• 1 I don't believe the exception differs because it is a component. Can you indicate which line in your example code is throwing the exception? Maybe you would like to rework your question to emphasis that that the issue is getting a default record in preview mode rather than the resulting exception. –  Daniel Ballinger Commented Mar 2, 2015 at 18:47
• 2 The problem is doing this in Apex: Opportunity lo = [SELECT Id, Name FROM Opportunity WHERE Id = :strOptID LIMIT 1]; . You need to assign the SOQL results to a List<Opportunity> , check the resulting List size and then get lo from the first record in the list. If the list is empty you need to return. –  Daniel Ballinger Commented Mar 2, 2015 at 18:56

3 Answers 3

General rule - don't return result of SOQL to an object, but return it to a list of objects. After querying items, check the list. Don't do

In your case Opportunity. But you have two places where this error may appear.

I would suggest that you refactor your queryDetailData method to query into a list instead of a single record. Then, if the resulting size of the List is 0, then set a boolean rendered flag to false, thus hiding the component, and preventing the error from occurring when you are in preview mode.

• Thanks JimRae. Great idea about the rendered flag, but since it's an email that's related to one record, (Limit 1), can't I still just check for the return opportunity being null after the SOQL? Thanks again. –  user2223 Commented Mar 2, 2015 at 21:39
• You could, but you may still have the no results error. The other way to handle this would be to put the SOQL query in a try/catch block, then catch the Query Exception and as long as it is "no rows" related, you could set the no render flag, or handle the optional processing another way of your choosing. –  JimRae Commented Mar 2, 2015 at 22:19

tempOppty is a single sObject. May be the soql is not assigning any record to this. You would want to convert this into a list and proceed accordingly.

You must log in to answer this question.

Not the answer you're looking for browse other questions tagged visualforce visualforce-component ..

• The Overflow Blog
• Scaling systems to manage all the metadata ABOUT the data
• Navigating cities of code with Norris Numbers
• Featured on Meta
• We've made changes to our Terms of Service & Privacy Policy - July 2024
• Bringing clarity to status tag usage on meta sites

Hot Network Questions

• How is delayed luggage returned to its owners from a location with infrequent flights?
• Why don't programming languages or IDEs support attaching descriptive metadata to variables?
• Why are the perfect fifth and fourth called "perfect" in 12-ET when they differ by approximately 2 cents from just intonation?
• Is there an "ESA Astronaut Alexander Gerst Observatory" in Künzelsau, Germany? If so, what's it like?
• Are the US or its European allies offering Iran anything in return for de-escalation?
• Decent 900 MHz radome material from a hardware store
• Using "where" to modify people
• Why are these simple equations so slow to `Solve`?
• How can one design earplugs so that they provide protection from loud noises, such as explosions or gunfire, while still allowing user to hear voices?
• Could a 3D sphere of fifths reveal more insights than the 2D circle of fifths?
• Communicate the intention to resign
• A burning devil shape rises into the sky like a sun
• Does full erase create all 0s or all 1s on the CD-RW?
• Can this Integer Linear Programming problem be solved in polynomial time?
• Claims of "badness" without a moral framework?
• Why does editing '/etc/shells' file using 'sudo open' show an error saying I don't own the file?
• Automotive Controller LDO Failures
• How to declutter a mobile app home screen with a floating “Create Video” component?
• What are these on my cabbages?
• Suitable tool bag for vintage centre pull brake bike
• Sharing course material from a previous lecturer with a new lecturer
• Would several years of appointment as a lecturer hurt you when you decide to go for a tenure-track position later on?
• In zsh, annotate each line in a file to which both stdout and stderr have been redirected with the line's source (stdout or stderr)
• Can I continue using technology after it is patented