Query Parent account of a Contact

Question

I need to be able to query the Contact's Parent Account and show it in apex page but I get an error for this. How do does it know that the person logged in parents to show . So right now in Partner Community there is a field called Parent ID which a user which is the contact has to click on it and then select its parent while making an account. I want to automatically assigned that to the user

public class newOpportunityController {

  public List<Account> parentAccount { get; private set; }
    public List<Account> parentAccount { get; private set; }
    parentAccount = [SELECT Account.Name, (SELECT Contact.LastName FROM Account.Contacts)
                           FROM Account ];

}

Answer 1

Your question is a bit vague but:

If you are using a standard controller for Contact and your VF page, your class could look like:

public class myTestController{

    public Account parentAccount{get;set;}

    public mytEstController(Apexpages.standardController con){
       //Ensure the AccountID field is pulled into the controller
       con.addFields(New String[]{'AccountID'});
       //Get the Contact record 
       Contact c = (Contact)con.getRecord();
       //Query for the account based on the contact
       parentAccount = [Select ID From Account where ID = c.AccountID];
    }



}

The above is only a start and does not account for the fact that the AccountID field may be on the page. You will need to add appropriate error handling as well