Sign Up ›
  • Nicholas Labrada
  • NEWBIE
  • 10 Points
  • Member since 2015
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 4
    Replies
SOLVED
7 replies

apex:repeat in which my starting point is a child object to a parent object and I want to access another set of child objects related to that parent

Hi,

I'd like some help trying to figure out the following. I am trying to build a visualforce email template that starts at object "case". "case" is a child object to parent object "Quote". I am attempting to do an <apex:repeat> in which I grab another child object "quote line items" which is child object to parent object "Quote". Is this possible? Here is my code:
  
<messaging:emailTemplate subject="Quote-to-Order Submission Received:{!relatedTo.Account}" recipientType="User" relatedToType="Case">
<messaging:htmlEmailBody>
<html>
    <body>
        <p>Dear {!relatedTo.Created_By_Quote__c},</p>
        <p>Thank you for submitting your quote-to-order request for Account Name: {!relatedTo.Account}. Your Case# is {!relatedTo.CaseNumber}. Below are you quote details: </p>
        
        <p><table border="1" cellpadding="5">
                        <tr > 
                            <th>Line Number</th><th>Part Number</th><th>Quantity</th><th>Unit Price</th><th>Line Total</th>
                        </tr>
                        <apex:repeat var="qline" value="{!relatedTo.Quote__r}">
                            <tr>
                            </tr>
                        </apex:repeat>                 
            </table>
        </p>
        
    </body>
</html>
</messaging:htmlEmailBody>
</messaging:emailTemplate>

 
SOLVED
7 replies

apex:repeat in which my starting point is a child object to a parent object and I want to access another set of child objects related to that parent

Hi,

I'd like some help trying to figure out the following. I am trying to build a visualforce email template that starts at object "case". "case" is a child object to parent object "Quote". I am attempting to do an <apex:repeat> in which I grab another child object "quote line items" which is child object to parent object "Quote". Is this possible? Here is my code:
  
<messaging:emailTemplate subject="Quote-to-Order Submission Received:{!relatedTo.Account}" recipientType="User" relatedToType="Case">
<messaging:htmlEmailBody>
<html>
    <body>
        <p>Dear {!relatedTo.Created_By_Quote__c},</p>
        <p>Thank you for submitting your quote-to-order request for Account Name: {!relatedTo.Account}. Your Case# is {!relatedTo.CaseNumber}. Below are you quote details: </p>
        
        <p><table border="1" cellpadding="5">
                        <tr > 
                            <th>Line Number</th><th>Part Number</th><th>Quantity</th><th>Unit Price</th><th>Line Total</th>
                        </tr>
                        <apex:repeat var="qline" value="{!relatedTo.Quote__r}">
                            <tr>
                            </tr>
                        </apex:repeat>                 
            </table>
        </p>
        
    </body>
</html>
</messaging:htmlEmailBody>
</messaging:emailTemplate>