AJO - Query in journey Condition

[Silvio6]

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)

[dugganab]

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})

[Silvio6]

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."

[dugganab]

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.

[Silvio6]

not working