Expand my Community achievements bar.

Dive in, experiment, and see how our AI Assistant Content Accelerator can transform your workflows with personalized, efficient content solutions through our newly designed playground experience.

AJO - Query in journey Condition

Avatar

Level 3

Hi, I have the following table from Query Service. This profile has those message_ids associated

Silvio6_0-1724945851778.png

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:

Silvio6_3-1724946047355.png

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

Silvio6_2-1724946001192.png

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)

4 Replies

Avatar

Employee

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

Avatar

Level 3

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

Avatar

Employee

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.

 

dugganab_0-1725074616387.png