salesforce apex list has no rows for assignment to sobject

Salesforce apex list class and methods with practice examples

List is one of the collections in apex. A list is an ordered collection of elements, where each element can be accessed by its index. Apex lists class provides a number of methods to handle groups of records in salesforce.

In this guide, we will dive into list manipulation in salesforce apex, explaining essential list methods to use for real-world business scenarios.

• How to Create a List in Apex

What are the list methods

Exception - list has no rows for assignment to sobject, exception - list index out of bounds, apex list practice examples, how to create a list.

To create a list , use the List keyword followed by angle brackets containing the data type.

Here is an example :

Note : Lists must always be initialized. If you operate on an uninitialized list, you may cause a null pointer exception.

Salesforce apex list class provides a rich set of methods to manipulate lists. These methods allow developers to perform a variety of operations, such as adding, removing, sorting, and searching elements within a list.

The following are some of the most important list class methods available in Salesforce.

This method adds an element to the end of the list.

This method adds all the elements from another list to the end of the current list.

This method removes all elements from the list.

4. contains

This method returns true if the list contains the specified element, otherwise it returns false.

This method returns the element at the specified index in the list.

This method returns the index of the first occurrence of the specified element in the list, or-1 if the element is not found.

This method returns true if the list is empty,otherwise it returns false.

This method removes the first occurrence of the specified element from the list.

This method replaces the element at the specified index in the list with the specified element.

This method returns the number of elements in the list.

This method sorts the elements in the list in ascending order, based on their natural ordering.

This exception happens when you try to use a value from a list that was created using a SOQL query, but the list is empty.

For example:

The select query always returns a list. Always check if the list is empty before accessing the values from the list.

The modified code for the above scenario is :

Apex throws a "List index out of bounds" exception when you try to access an element in a list using an index that doesn't exist in the list. Here is an example:

To avoid this happening in your code, always check the list size before accessing an index.

Following are a list of practice examples to learn and use the apex list methods . Click the following links to see the apex practice problems.

1. Add two string values to a list

Apex practice method to define and add two string values into a list.

2. Find the number of elements in a list

Apex practice method to find the number of elements in a list using apex list methods.

3. Insert an element at a specific index

Apex list practice example to add an element at specific index by using apex list methods.

4. Verify if an opportunity stage is in a list of final stages

Apex list method to verify if the opportunity stage belongs to one of the final stages.

5. Dedupe lead records in salesforce using apex

Learn to use apex list methods to deduplicate lead records in salesforce.

6. Find account ids from list of accounts

Retrieve account ids from any list of accounts using apex list methods.

Cookie Consent Manager

General information, required cookies, functional cookies, advertising cookies.

We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings. Privacy Statement

Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.

Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.

Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.

Cookie List

Apex error 'list has no rows for assignment to sobject'.

The following query is not returning any number of records: "[SELECT Id FROM Account WHERE Id = :Trigger.new[0].Account__c]" The error "List has no rows for assignment to SObject" occurs when query doesn't return any rows.

List has no rows for assignment to SObject although query returns rows

I am trying to display a selectList in a visualforce page using a custom controller i built.

I get an "List has no rows for assignment to SObject" error when trying to preview the page, but running the query in the developer console, returns the rows.

here is my page:

<apex:page Controller="BpmIcountPayment">

<apex:param name="first_name" value="Account.FirstName"/>

<apex:param name="last_name" value="Account.LastName"/>

<apex:param name="id" value="Account.idnumber__c"/>

<apex:param name="address" value="Account.Address"/>

<apex:form >

<apex:selectList value="{!productsTitle}" multiselect="false">

<apex:selectOptions value="{!ProductsLov}"></apex:selectOptions>

</apex:selectList>

</apex:form>

</apex:page>

and my controller:

public class BpmIcountPayment{

private final Account account;

public String productsTitle {

get { return 'products for sale'; }

public BpmIcountPayment() {

account = [SELECT Id, Name, Site FROM Account

WHERE Id = :ApexPages.currentPage().getParameters().get('id')];

public Account getAccount() {

return account;

public List<SelectOption> getProductsLov() {

List<SelectOption> products = new List<SelectOption>();

List<Product2> productsList = [SELECT Id, Name, Family

FROM Product2

WHERE (Family = 'ShopProduct')

OR (Family = 'CourseParent')

OR (Family = 'SFCourseProgram')];

system.debug(productsList);

for (Product2 currProduct : productsList) {

products.add(new SelectOption(currProduct.Id, currProduct.Name));

return products;

• Nach "Am hilfreichsten" sortieren
• Nach Datum sortieren

preview url : 

https://xyz-dev-ed--c.ap6.visual.force.com/apex/vfpage_name?core.apexpages.request.devconsole=1

after apex/vfpage_name pass the id of any account like this: 

https://xyz-dev-ed--c.ap6.visual.force.com/apex/vfpage_name?id=0012800000toEnM

Please try this, if the problem sustain then let me know.

• Unterstreichen
• Durchstreichen
• Liste mit Gliederungspunkten
• Nummerierte Liste
• Link hinzufügen
• Bild einfügen
• Dateien anhängen