How do I add info from a custom object to my visual force page when I'm already using a standard controller?

Question

Here is what I am trying to do.

I have a visualforce page, I have information from the account object populating in a table.

I'd also like to populate information from my custom object to that visualforce page. How do I do that? I would be okay using another table, I'm not picky on how that information shows up just as long as it works.

My code is simple, I'm a beginner.

<apex:page standardController="Account" recordSetVar="amanda">
    <apex:pageBlock >
      <apex:pageBlockTable value="{!amanda}" var="acc">
       <apex:column value="{!acc.Name}"/>
      </apex:pageBlockTable>
    </apex:pageBlock>
</apex:page>

The API name of the custom object would be Milestone__c, I would like to bring over name, Where_are_we__c, and Name__c

Answer 1

You'll need to use Apex or the API to get this data. Visualforce itself can't do what you're trying to do without some help.

<apex:page controller="MyPageController">
  <apex:pageBlock>
    <apex:pageBlockTable value="{!accounts}" var="accountRecord">
      <apex:column value="{!accountRecord.Name}" headerValue="Name" />
      <apex:column> 
        <apex:dataTable value="{!accountRecord.Milestones__r}" var="milestone">
          <apex:column value="{!milestone.Name}" headerValue="Name" />
          <apex:column value="{!milestone.Where_are_we__c}" headerValue="Where Are We?" />
          <apex:column value="{!milestone.Name__c}" headerValue="Custom Name" />
        </apex:dataTable>
      </apex:column>
    </apex:pageBlockTable>
  </apex:pageBlock>
</apex:page>

And for the Apex code:

public class MyPageController {
  public Account[] getAccounts() {
    return [
      SELECT Name, (
        SELECT Name, Where_Are_We__c, Name__c 
        FROM Milestones__r
      )
      FROM Account
    ];
  }
}

Note that there's a limit of 50,000 records unless you use the "readOnly" property on apex:page. You can also add database filters to selectively choose which records you want to show.