Hi, I have the following table from Query Service. This profile has those message_ids associated
I want to know if the message_id = 2c2de416-27bc-41a5-8c83-4a8cebd79da4 is part of the message_ids associated to that profile.
But when I create the condition:
and test for test@test.com, this is my result: it takes the false path and, as I showed in table, that message_id is part of his profile
So how can I achieve my goal of check if a message_id is part of ALL message_ids received for a profile? Is there a way to look for a value in a list? For example, look for my message_id in a list of message_ids for that profile?
Thanks.
(I used message_id name but I know it's messageID, no worries with that, I'm using the correct name)
Views
Replies
Total Likes
Can you validate it on the following lines ?
Example -
in('<messageIdPlaceholder>',#{ExperiencePlatform.ajo_ds_email_received.experienceevent.all(inLastDays(currentDataPackField.timestamp,7))._experience.
customerJourneyManagement.messageExecution.messageID})
Views
Replies
Total Likes
mm I tried this:
in("2c2de416-27bc-41a5-8c83-4a8cebd79da4",#{ExperiencePlatform.ajo_ds_email_received.experienceevent.all(inLastDays(#{ExperiencePlatform.ajo_ds_email_received.experienceevent.timestamp},7))._experience.customerJourneyManagement.messageExecution.messageID})
but not working: "The expression is invalid : The expression has not a valid structure."
Views
Replies
Total Likes
Interesting, I see the expression validates fine. Can you add it from the expression editor and replace .at(0) with the relevant filters per the below example.
Views
Replies
Total Likes
not working
Views
Replies
Total Likes