[SalesForce] Get Opportunity’s Account

Question

Why I can't access to opportunity account name on apex/vf ?

Backgound

I'm creating a opportunity VF page, extending the standarcontroller:

 <apex:page standardController="Opportunity" extensions="test1Extension">

On my extension class I'm setting the opp object using:

 opp = (Opportunity) controller.getRecord();

When I try to reference account on the vf by {!opp.Account.Name} I get this error:

SObject row was retrieved via SOQL without querying the requested
field: Opportunity.Account

In addition, I've tried to query the account using a subquery:

opp =[select Id, (select Id from Account where Id= opportunity.AccountId) from Opportunity where id=:opp.Id];

Or Account acc = [select Id from Account where id=:opp.AccountId];

SObject row was retrieved via SOQL without querying the requested
field: Opportunity.AccountId

Summarizing

1) Why I can't reference Account from Opportunity ?
2) What is the proper why to make that sub-query?

thx in advance

Best Answer

Since you have the standard controller there you can refer to fields through that and they will be automatically queried. In this case you would refer to

{!Opportunity.account.name}

on the VF and that would work.
The prefix Opportunity. is referring to the standard controller (rather than your extension variable Opp.
Any fields that you include on the VF page from the Standard Controller (Opportunity.) will be automatically queried. You don't need to do anything in your extension to make that data available.

If you had wanted to use your own variable Opp on the page (to have Opp.Account.Name), you were nearly there with the approach you had you just needed to phrase the query correctly, the syntax you would want is

Opp = [select id, account.name from opportunity where id=:opp.Id]

Related Solutions

[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;"/>

[SalesForce] common.apex.runtime.impl.ExecutionException: SObject row was retrieved via SOQL without querying the requested field: Contact.bp_Billing_Address_1__c

You have to query "Contact.bp_Billing_Address_1__c" this field too. like:

List <CaseContactRole> myCases =  [SELECT                          
                                cases.createddate,
                                cases.casenumber, 
                                cases.StreetType__c, 
                                cases.AptNum__c, 
                                cases.ZipCode__c, 
                                cases.DirPrefix__c,
                                cases.DirSuffix__c,
                                cases.StreetName__c, 
                                cases.State__c, 
                                cases.LotNum__c, 
                                cases.HouseNum__c,
                                cases.BP_IsTXNM__c,
                                cases.fldSBlockNum__c,
                                cases.order__r.BP_fldPendType__c,
                                contact.name ,                                   
                                contact.bp_CAddress_1__c , 
                                contact.bp_CCity__c,
                                contact.bp_CState__c, 
                                contact.bp_CZipCode__c,
                                Contact.bp_Billing_Address_1__c
                                FROM 
                                    CaseContactRole 
                                WHERE 
                                    Role = 'Primary Contact'];