Skip to main content
Melissa_Neikirk
Melissa_Neikirk
Level 2
June 25, 2018
Question

New to Velocity - How do I get the most recent object record?

  • June 25, 2018
  • 10 replies
  • 5511 views

This has been asked a few times, and I have looked through and tried most of those solutions. However, in my case it still seems not to be working, and I am not sure why.

Here is an example of the cleanest script I have tried, an adaption of script given to another user for the same issue. 

#if( $AdPotentialCancellation_cList && !$AdPotentialCancellation_cList.isEmpty() ) 
#set( $firstItem = $AdPotentialCancellation_cList[0] ) 
#set( $lastItem = $AdPotentialCancellation_cList[$math.sub($AdPotentialCancellation_cList.size(),1)] ) 
#end
$lastItem.Name

Some things to note: AdPotentialCancellation is the name of the SFDC Custom Object being referenced. 'Name' is the field I am trying to get to populate in the email with the above script. I have other fields that I also need to populate in the email.

These are the other fields I would like to populate in separate email scripts in the email: 'Declined_Amount__c' & 'Decline_Date__c'. I have done some work on formatting the amount field to be currency and the date to be a date -- it works only if I used the standard code that grabs the oldest field.

Decline Amount Code:

#set($amount = $number.format("$0", ${AdPotentialCancellation__cList.get(0).Declined_Amount__c}))
${amount}

Decline Date Code:

#set( $dateOptions = {  
  "formats" : {  
    "userin" : "yyyy-MM-dd",  
    "userout" : "MMMM dd, yyyy"  
  },  
  "timezones" : {  
    "userin" : "America/Los_Angeles",  
    "userout" : "America/Los_Angeles"  
  },  
  "locale" : $date.getLocale()  
} )  
#set( $declineDatelike = ${AdPotentialCancellation__cList.get(0).Decline_Date__c} )  
#set( $declineDate = $convert.parseDate(  
  $declineDatelike,  
  $dateOptions.formats.userin,  
  $dateOptions.locale,  
  $date.getTimeZone().getTimeZone($dateOptions.timezones.userin)  
) )  
#set( $declineDate_formatted = $date.format(  
  $dateOptions.formats.userout,  
  $declineDate,  
  $dateOptions.locale,  
  $date.getTimeZone().getTimeZone($dateOptions.timezones.userout)  
) )  
${declineDate_formatted}

An issue I keep seeingis that the email renders the $lastItem.Name, ${amount} or  ${declineDate_formatted} instead of any data. I used the below code here to confirm that the data exists for the test lead on the object, and made sure to check all the fields I need in the right column to see the full list. I can see data is there for all fields.

#if( !$context.contains("AdPotentialCancellation__cList") )  
  AdPotentialCancellation list does not exist in context.  
#else  
  AdPotentialCancellation list exists.  
  #set( $listSize = $AdPotentialCancellation__cList.size() )  
  #if( $listSize == 0 )  
    List is empty.  
  #else  
    List size: $listSize.  
    List values: ${display.list($AdPotentialCancellation__cList,"<br>")}  
  #end  
#end 

Can anyone help me understand where I might be going wrong, or other ways I can troubleshoot the code? Thank you!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

10 replies

SanfordWhiteman
SanfordWhiteman
Level 10
June 26, 2018

What you've left out is any example of the data actually stored in these objects, and the errors/output you're seeing.

What's the output (in the text part of an email, as that's easier to troubleshoot) of:

$display.list($AdPotentialCancellation_cList,"\u000a")

Anyway, there's nothing inherently wrong with your first bit of code, but if it doesn't match the shape of the ArrayList of objects then it's going to throw an error:

Note you can order the list by any field (as long as it's checked off in Script Editor). For example, to order by your Decline_Date__c in ascending order:

#set( $objectsByDeclineDateAsc = $sorter.sort($AdPotentialCancellation_cList,"Decline_Date__c") )
#set( $firstItem = $objectsByDeclineDateAsc )
#set( $lastItem = $objectsByDeclineDateAsc )
Melissa_Neikirk
Melissa_NeikirkAuthor
Level 2
June 26, 2018

Thanks, Sanford! I appreciate your quick response.

When I input the code above what I see in the email text is this:

When I copy the code above exactly for ordering by Decline_Date_c the email text display is empty/blank.

To your point about not showing what displays in the email for the code in my original post, here is what happens using the same lead for each code instance.

  • When I do the code to get the most recent Name (which is our version of a case number) this is what displays in the email.
    • $lastItem.Name.
  • When I do the troubleshooting code from my original post this is what displays in the email.
    • AdPotentialCancellation list exists.
    • List size: 2.
    • List values: {Declined_Amount__c=1493.99, Decline_Date__c=2017-07-26, Name=A-469957, Status__c=Saved} {Declined_Amount__c=150, Decline_Date__c=2018-06-26, Name=A-561375, Status__c=Pending}
  • When I do the date code from my original post this is what displays in the email.
    • July 26, 2017
SanfordWhiteman
SanfordWhiteman
Level 10
June 26, 2018

Something's not quite right in your testing setup.  If $AdPotentialCancellation_cList is in the Velocity context (checked off in the tree in Script Editor) and is not empty, then this line cannot fail:

$display.list($AdPotentialCancellation_cList,"\u000a")

Are you testing using Preview by List with a person known to have AdPotentionalCancellation records?

List values: {Declined_Amount__c=1493.99, Decline_Date__c=2017-07-26, Name=A-469957, Status__c=Saved} {Declined_Amount__c=150, Decline_Date__c=2018-06-26, Name=A-561375, Status__c=Pending}

If I create a list exactly like this, I don't have a problem.

Setup:

#set( $AdPotentialCancellation_cList = [
{
  "Declined_Amount__c" : 1493.99, 
  "Decline_Date__c" : "2017-07-26", 
  "Name" : "A-469957", 
  "Status__c" : "Saved" 
},
{
  "Declined_Amount__c" : 150, 
  "Decline_Date__c" : "2018-06-26",
  "Name" : "A-561375", 
  "Status__c" : "Pending"
}
] )
#if( $AdPotentialCancellation_cList && !$AdPotentialCancellation_cList.isEmpty() )   
#set( $firstItem = $AdPotentialCancellation_cList[0] )   
#set( $lastItem = $AdPotentialCancellation_cList[$math.sub($AdPotentialCancellation_cList.size(),1)] )   
All items: 
$display.list($AdPotentialCancellation_cList,"\u000a")
First item: $firstItem.Name
Last item: $lastItem.Name
#end

Output:

All items:
{Declined_Amount__c=1493.99, Decline_Date__c=2017-07-26, Name=A-469957, Status__c=Saved}
{Declined_Amount__c=150, Decline_Date__c=2018-06-26, Name=A-561375, Status__c=Pending}
First item: A-469957
Last item: A-561375
Terms & ConditionsAccessibility statement

Loading footer...