in email, I am using my token as a email script to display custom objects data but when displaying data in email it display data for old value as well as new value I want to refrain the old data and want to display only new data in email.
Yes!
Date created and Date updated is also being mapped in the CO list. with data type datetime.
Hence, date updated can be used to sort it out.
Then the modification to the code from your other thread is:
## constants/strings
#set( $DEFAULT_OUTPUT_NO_LIST = "No records in list." )
#set( $DEFAULT_OUTPUT_NO_PROPERTY = 0 )
## loop, paying attn to emptiness and null-ness
#if( $someObjectList.isEmpty() )
#set( $outputBuilder = $DEFAULT_OUTPUT_NO_LIST )
#else
#foreach( $someObjectName in $sorter.sort($someObjectList, "someDateProperty:desc") )
#if( !$display.alt($someObjectName["somePropertyName"],"").isEmpty() )
#set( $outputBuilder = $someObjectName["somePropertyName"] )
#break
#end
#end
#set( $outputBuilder = $display.alt($outputBuilder, $DEFAULT_OUTPUT_NO_PROPERTY) )
#end
${outputBuilder}
The list is sorted by the DateTime field in descending order. When a match is found then you #break out of the #foreach so the output is not overwritten. This is a crucial pattern to understand in Velocity. There's no formal way to filter a list, you loop-until-break.
You'll need to insert the actual field names from your instance of course, this is a framework with generic property names. someDateProperty would be replaced with your DateTime field. Keep the :desc as that means descending order.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.