[SalesForce] Access parent object fields in VisualForce email template subject

I'm trying to display a parent field value in the subject line of a VisualForce email template and I'm running into problems. The use case is that we're going to fire an email alert that is based on a workflow rule on the child object.

Here's what I've got:

Parent object: Case

Parent object field: Case Number

Child object: n2de__Distribution_log__c

And here's how I've started, but I'm running into an error when saving. What am I missing?

<messaging:emailTemplate subject="Alert: 25 Minutes Before {!relatedTo.Case__r.CaseNumber} Misses Target" recipientType="User" relatedToType="n2de__Distribution_log__c">
<messaging:plainTextEmailBody >
Congratulations!
This is your new Visualforce Email Template.
</messaging:plainTextEmailBody>
</messaging:emailTemplate>

The error text is:

Error: Invalid field Case__r for SObject n2de__Distribution_log__c

Best Answer

I spun up Distribution Engine on my Developer instance, and it looks like the field you want is actually n2de__Case__r.

Try {!relatedTo.n2de__Case__r.CaseNumber}

Related Solutions

[SalesForce] Salesforce Visualforce Email Template {!Recipient.Name} does not have the correct value

I have found this known issue, it seems appropriate:

https://success.salesforce.com/issues_view?id=a1p30000000SdBfAAK

There is a work-around which is to use the relationship from the relatedTo record:

Use {!relatedTo..name}

So maybe try (guessing the lookup field API name):

{!Request__c.Reviewer_1__r.Name}

[SalesForce] Access child object’s fields in visualforce email template

I think you need to use visualforce email template with controller.

Controller "

    ppublic class GetChild {
    private final List<Account> accounts;


    public GetChild() {
        accounts = [SELECT Name,(SELECT CreatedBy.Name FROM Notes) FROM Account];
    }

    public List<Account> getchildNotes() {

       Return accounts;
    }
}

Create a component and name it SmithNotes and access the child values something like this

<apex:component controller="GetChild" access="global">
    <apex:variable var="count" value="{!0}"/> //declare
        <apex:dataTable value="{!childNotes}" var="s_account">
            <apex:column >
                <apex:facet name="header">Notes Title</apex:facet>
                {!s_account.Notes[count].title}
            </apex:column>
        </apex:dataTable>
        <apex:variable var="count" value="{!count + 1}"/> //increment
   </apex:component>

In your visualforce email template include the component.

<messaging:emailTemplate subject="Embedding Apex Code" recipientType="Contact" relatedToType="Opportunity">
    <messaging:htmlEmailBody>
        <p>As you requested here are the notes</p>
        <c:SmithNotes/>
        <p>Hope this helps with the {!relatedToType}.</p>
    </messaging:htmlEmailBody>
</messaging:emailTemplate>

Best Answer

Related Solutions

[SalesForce] Salesforce Visualforce Email Template {!Recipient.Name} does not have the correct value

[SalesForce] Access child object’s fields in visualforce email template

Related Topic