[SalesForce] Error message: SObject row was retrieved via SOQL without querying the requested field

I receive the following error:

SObject row was retrieved via SOQL without querying the requested field: Installation__c.Name

Controller extension on custom object:

public class CrewWorkDetailController{

    public final Installation__c installation {get; private set;}

    public CrewWorkDetailController(ApexPages.StandardController stdController)
    {
        this.installation = (Installation__c) stdController.getRecord() ;
    }
}

View:

<apex:page standardController="Installation__c" extensions="CrewWorkDetailController">
    {!installation.Name}
</apex:page>

This is based on this example. Any ideas?

I tried renaming my variable and still does not work.

Best Answer

The only fields that are queried by default are the fields that are explicitly bound to the main standard controller during the page's construction (before the constructor of your extension is called).

You have two choices here:

1) You can use StandardController.reset() and StandardController.addFields() to add Name as a field to query.

2) You can bind directly the standard controller's record by using the name of the object:

<apex:page standardController="Installation__c" extensions="CrewWorkDetailController">
    {!installation__c.Name}
</apex:page>

Related Solutions

[SalesForce] SObject row was retrieved via SOQL without querying the requested field: CustomLeadc.CompanyName

Generally what this means is that your controller is trying to reference a field that has not been populated. By default, Visualforce controllers will retrieve values for all fields referenced in the Visualforce page and no others. You can solve this in one of two ways:

Explicitly retrieve the field in the controller's method
Add the field to your VF page with an output field that has rendered="false":
```
<apex:outputText value="{!CompanyName_c}" rendered="false" />
```

My preference is to use the outputText field for the following reasons:

It saves a SOQL call
I think it aids in maintenance. In the future other admins will see that the field is necessary to the VF page's functionality, even if it is not visible.

Update

As Andrew mentioned in the comments, there is a third option: use the addFields() method on the StandardController. This might be the cleanest option since it does not add clutter to your VF page.

[SalesForce] Commandbutton Link to Visualforce Page Giving “SObject row was retrieved via SOQL without querying the requested field”

The commandButton's attribute action is not to use as forwarding element. Here some info from the docs:

The action method invoked by the AJAX request to the server. Use merge-field syntax to reference the method. For example, action="{!save}" references the save method in the controller.

Read the full doc here.

If you want to redirect the user to another page just create a PageReference apex method for that and reference it in the command button:

public PageReference redirectUser(){
    PageReference ref = new PageReference('/apex/MemberFileChecklist?id=' + contact.id);
    return ref;
}

<apex:commandbutton value="TMC Member Checklist" action="{!redirectUser}"/>

More info about PageReference.

Alternatively, you can use onclick attribute and redirect with some javascript (if you don't want to create extra apex method). In this case you dont't need the action anymore:

<apex:commandbutton value="TMC Member Checklist" 
                    onclick="window.location='/apex/MemberFileChecklist?id={!Contact.id}'; return false;"/>

Best Answer

Related Solutions

[SalesForce] SObject row was retrieved via SOQL without querying the requested field: CustomLead__c.CompanyName__

[SalesForce] Commandbutton Link to Visualforce Page Giving “SObject row was retrieved via SOQL without querying the requested field”

Related Topic

[SalesForce] SObject row was retrieved via SOQL without querying the requested field: CustomLeadc.CompanyName