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
Views
Likes
Replies