AJO - Query in journey Condition | Community
Skip to main content
Silvio6
Level 5
August 29, 2024
Question

AJO - Query in journey Condition

  • August 29, 2024
  • 1 reply
  • 900 views

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)

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Mohan_Dugganab
Adobe Employee
Adobe Employee
August 29, 2024

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
Silvio6Author
Level 5
August 30, 2024

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

Mohan_Dugganab
Adobe Employee
Adobe Employee
August 31, 2024

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.