function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Chris Morrison 7Chris Morrison 7 

Related records visualforce

Working on a page with a repeat section that pulls in Opportunities related to an Account (standard controller). Inside the repeat I need to show the Contact Roles for each given Opportunity listed. So far I am not finding a way to do this. See related VF and extension controller. I am sure this is super simple but I can't figure it out for the life of me. 

Apex: 
public class BlueSheetExtension {
    
    public List <Opportunity> WonOpty {get; set;}
    public List <Opportunity> OpenOpty {get; set;}
    public List <Contact> contacts {get; set;}
    public List <OpportunityContactRole> wonOptyRoles {get; set;}
    public List <OpportunityContactRole> openOptyRole {get; set;}
    public String prodlist {get; set;}
    
    
    public BlueSheetExtension(ApexPages.StandardController controller) {
        
        wonOpty = [Select Id, Name, Amount, Owner.Name, StageName, Last_Touch_Date__c, CloseDate, Goal__c, Actions_For_Goal__c, 
                Status_of_Action__c, red_flags__c, risks__c, terms_months__c, auto_renew__c, Auto_Renew_Months__c From Opportunity 
                Where IsWon = TRUE AND AccountId= :ApexPages.currentPage().getParameters().get('id')];
        
       OpenOpty = [Select Id, Name, Amount, Owner.Name, StageName, Last_Touch_Date__c, CloseDate, Goal__c, Actions_For_Goal__c, 
                Status_of_Action__c, red_flags__c, risks__c, terms_months__c, auto_renew__c, Auto_Renew_Months__c From Opportunity 
                Where IsClosed = FALSE AND AccountId= :ApexPages.currentPage().getParameters().get('id')];
           
        
        Contacts = [Select Id, Name, Title, Owner.Name, Buyer_Type__c, Mode__c, Meeting_Frequency__c 
               From Contact Where AccountId = :ApexPages.currentPage().getParameters().get('id')];
        
        wonOptyRoles = [Select Id, OpportunityId, Opportunity.Name, Contact.Name, Contact.Title, Contact.Owner.Name, Contact.Buyer_Type__c, Contact.Mode__C, Contact.Meeting_Frequency__c 
                From OpportunityContactRole where OpportunityId IN 
                (Select Id from Opportunity Where IsWon = TRUE AND AccountId= :ApexPages.currentPage().getParameters().get('id') )];
        
        openOptyRole = [Select Id, OpportunityId, Opportunity.Name, Contact.Name, Contact.Title, Contact.Owner.Name, Contact.Buyer_Type__c, Contact.Mode__C, Contact.Meeting_Frequency__c 
                From OpportunityContactRole where OpportunityId IN 
                (Select Id from Opportunity Where IsClosed = FALSE AND AccountId= :ApexPages.currentPage().getParameters().get('id') )];
    }

}



VF markup: 
<apex:page lightningStylesheets="true" standardController="Account" extensions="BlueSheetExtension">
  <div style="text-align: center;"><img src="{!$Resource.EnveraLogo}"/>
    </div>
   <div style="text-align: center; font-size: 150%;">
        Blue Sheet for {!Account.Name}
    </div>
    <apex:sectionHeader title="Section I. Account Summary"/> <!--Basic Account information-->
    <apex:pageBlock >
        <apex:pageBlockSection >
            <apex:outputField value="{!Account.Name}" label="Account Name:"/>
            <apex:outputField value="{!Account.Owner.Name}" label="Account Owner:"/>         
        </apex:pageBlockSection>
        <apex:pageBlockSection >
            <apex:outputField value="{!Account.Account_Summary__c}" label="Account Summary:"/>       
        </apex:pageBlockSection>
    </apex:pageBlock>  
    	<apex:sectionHeader title="Section II. Current Services"/> <!--Data for this section comes from Closed Won Opportunities only-->
    	<apex:repeat value="{!WonOpty}" var="w">
    		<apex:pageBlock >      
        	<apex:pageBlockSection >
            	<apex:outputField value="{!w.Name}" label="Opportunity Name:"/>
                <apex:pageBlockSectionItem ></apex:pageBlockSectionItem>
            	<apex:outputField value="{!Account.Name}" label="Product:"/>
            	<apex:outputField value="{!w.Amount}" label="Amount:"/>
            	<apex:outputField value="{!w.Owner.Name}" label="Opportunity Owner:"/>
            	<apex:outputField value="{!w.StageName}" label="Stage:"/>
            	<apex:outputField value="{!w.Last_Touch_Date__c}" label="Last Touch Date:"/>
            	<apex:outputField value="{!w.CloseDate}" label="Close Date:"/>
            	<apex:outputField value="{!w.terms_months__c}" label="Terms Months:"/>
            	<apex:outputField value="{!w.Auto_Renew__c}" label="Auto Renew:"/>
            	<apex:pageBlockSectionItem ></apex:pageBlockSectionItem>
            	<apex:outputField value="{!w.Auto_Renew_Months__c}" label="Auto Renew Months:"/>
                <apex:pageBlockSectionItem ></apex:pageBlockSectionItem>
                <apex:pageBlockSectionItem ></apex:pageBlockSectionItem>
            	<apex:outputField value="{!w.Goal__c}" label="Goal:"/>
            	<apex:outputField value="{!w.Actions_For_Goal__c}" label="Actions for Goal:"/>
            	<apex:outputField value="{!w.Status_of_Action__c}" label="Status for Action"/>
            	<apex:pageBlockSectionItem ></apex:pageBlockSectionItem>
            	<apex:outputField value="{!w.Red_Flags__c}" label="Red Flags"/>
            	<apex:outputField value="{!w.Risks__c}" label="Risks"/>
            	</apex:pageBlockSection>
            <apex:pageBlockSection columns="1" title="Buying Influence" ><!--Contact Roles for the related Opportunity -->  
            <!--Data Table used because of repeating section data shenanigans. I don't like it either and I am sure there is a better way-->  
            <apex:dataTable title="Buyer Influence" value="{!WonOptyRoles}" var="wor"  rules="rows" style="border-color: #f3f2f2">    
       		 <apex:column >
            	<apex:facet name="header">Name</apex:facet>
            	<apex:outputText value="{!wor.contact.name}" style="display: {!IF(w.id=wor.OpportunityId,'table-row','none')}"/>
       		 </apex:column>
        	<apex:column >
            	<apex:facet name="header">Title</apex:facet>
            	<apex:outputText value="{!wor.contact.title}" style="display: {!IF(w.id=wor.OpportunityId,'table-row','none')}"/>
        	</apex:column>
                <apex:column >
            	<apex:facet name="header">Contact Owner</apex:facet>
            	<apex:outputText value="{!wor.contact.owner.name}" style="display: {!IF(w.id=wor.OpportunityId,'table-row','none')}"/>
        	</apex:column>
                <apex:column >
            	<apex:facet name="header">Buyer Type</apex:facet>
            	<apex:outputText value="{!wor.contact.Buyer_Type__c}" style="display: {!IF(w.id=wor.OpportunityId,'table-row','none')}"/>
        	</apex:column>
                <apex:column >
            	<apex:facet name="header">Mode</apex:facet>
            	<apex:outputText value="{!wor.contact.Mode__c}" style="display: {!IF(w.id=wor.OpportunityId,'table-row','none')}"/>
        	</apex:column>
                <apex:column >
            	<apex:facet name="header">Meeting Frequency</apex:facet>
            	<apex:outputText value="{!wor.contact.Meeting_Frequency__c}" style="display: {!IF(w.id=wor.OpportunityId,'table-row','none')}"/>
        	</apex:column>
            </apex:dataTable>
            </apex:pageBlockSection>
            </apex:pageBlock>
    	</apex:repeat>
Paul S.Paul S.
Chris - you need to sub query for the opp contact roles.  Use the following as a guide.

Vf Page: 
<apex:page standardController="Account" extensions="NestedRepeatPageExtension">

    <table border="0" >

        <apex:repeat var="opp" value="{!oppList}">

            <tr>
                <td>{!opp.Name}</td>
            </tr>
            
            <apex:repeat var="ocr" value="{!opp.OpportunityContactRoles}">

                <tr>
                    <td>{!ocr.Contact.Name}</td>
                </tr>
            
            </apex:repeat>                         

        </apex:repeat> 

    </table>

</apex:page>
Controller extension 
public class NestedRepeatPageExtension
{
    public List<Opportunity> oppList {get;set;}
    
    public NestedRepeatPageExtension(ApexPages.StandardController controller)
    {
        oppList=[SELECT Id, Name, (SELECT Contact.Name FROM OpportunityContactRoles) FROM Opportunity WHERE Account.Name = 'Edge Communications'];
    }
}