Velocity Script sorting on multiple characteristics

Question

I am trying to write a Velocity Script that will populate a field from a custom object into an email. The logic in the script needs to identify the correct custom object to use. Specifically, I want the most recently updated record with a specific status. I tried using this code, but it did not always identify the correct custom object.

#set( $sortedList = $sorter.sort($masterOrder_cList,["status:asc","UpdatedAt:desc"]) )
${sortedList.get(0).COFieldName}

Any tips are appreciated. 
 
What I really want to do is create a work around for the fact that trigger tokens do not work with the Custom Object is Updated trigger....so if you have any ideas on that front, I would also be interested.
 
Thank you!

SanfordWhiteman · Accepted Answer

Thank you for responding, Sandford! My status options are "cart", "quote" and "order" so my initial code was looking for "carts" which I could do simply by sorting alphabetically on status.

Hmm, sort of haphazard way of getting the data — not that I haven’t done it myself! But it’s too dependent on alpha sorting.

The better way is to create a new ArrayList and copy matching objects into that list:

#set( $filteredList = [] )
#foreach( $object in $originalList )
#if( $somecriteria.equals(true) )
#set( $void = $filteredList.add($object) )
#end
#end

SanfordWhiteman · Answer

Specifically, I want the most recently updated record with a specific status. I tried using this code, but it did not always identify the correct custom object.#set( $sortedList = $sorter.sort($masterOrder_cList,["status:asc","UpdatedAt:desc"]) ) ${sortedList.get(0).COFieldName}

It’s not clear what you mean by “with a specific status”. Your code is correct if you want to sort by a field called status, then by a field called UpdatedAt. (Note the standard field in Custom Objects is updatedAt with a lowercase “u”, so this is kind of surprising.)

The code is not filtering the list to only reveal objects with one particular status.

Sign up

Login with SSO

Login to the community

Login with SSO