date field with custom object to add if loop

Question

I have the following code, which formats date exactly the way I need it.
The issue is I only want to show the date in email which matches correct $eventid for customers.
 
I tried this loop but nothing populates:
 
#foreach( $eventid in $oN24Attendee_cList )
#if( $eventid.equals("2862094") )
$eventdatetime_formatted
#end
#end
----------------
Full code 
 
## get the size of the list of Custom object
## remove one from the size of the list to reference the right object in the array (arrays start at zero, not 1)
#set( $lastIndex = $math.sub($listlength,1) )
## convert the Service Start Date string to a date
#set( $dateOptions = {
"formats" : {
"userin" : "yyyy-MM-dd hh:mm",
"userout" : "dd MMMM yyyy hh:mm a"
},
"timezones" : {
"userin" : "America/Chicago",
"userout" : "Europe/London"
},
"locale" : $date.getLocale()
} )
#set( $eventdatetimelike = $oN24Attendee_cList.get($lastIndex).eventdatetime )
#set( $eventdatetime = $convert.parseDate(
$eventdatetimelike,
$dateOptions.formats.userin,
$dateOptions.locale,
$date.getTimeZone().getTimeZone($dateOptions.timezones.userin)
) )
## convert the date to a different format
#set( $eventdatetime_formatted = $date.format(
$dateOptions.formats.userout,
$eventdatetime,
$dateOptions.locale,
$date.getTimeZone().getTimeZone($dateOptions.timezones.userout)
) )
#foreach( $eventid in $oN24Attendee_cList )
#if( $eventid.equals("2862094") )
$eventdatetime_formatted
#end
#end

SanfordWhiteman · Accepted Answer

As you can see the from the eventid: 2862094 so the date should be

17 February 2021 3:00 PM

As you can see the from the eventid: 2862094 so the date should be 17 February 2021 3:00 PM

Not really, the code is doing exactly what you should expect it to do!

Your $eventdatetimelike variable is always built from the eventdatetime property of the last item in the list. That's how you wrote it:

#set( $eventdatetimelike = $oN24Attendee_cList.get($lastIndex).eventdatetime )

So that value is

2021-04-19 09:00:00

per your dump of the list.

If you want $eventdatetimelike, and in turn $eventdatetime, to be the date of the matching item, then you can't build it from the last item.

SanfordWhiteman · Answer

In this loop...#foreach( $eventid in $oN24Attendee_cList )#if( $eventid.equals("2862094") )$eventdatetime_formatted#end#end... you're comparing the entire (Map) object $eventid to the value "2862094". That's not what you want. You should be comparing the value of a particular key in the object to your target string, i.e.#foreach( $event in $oN24Attendee_cList )#if( $event.eventid.equals("2862094") )$eventdatetime_formatted#end#end (I used eventid as a placeholder. Not sure what the key is in your case, you'd know that by dragging the field onto the canvas.)

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded