@shubham10 Can you share your segmentation screenshot? 

Hello @Silvio6 try this?   matchRegExp(serializedList,'.*@asd\\.com.*' )     ~cheers, NN.

@montezh2001 Few options to check value in array:   1) array_contains 2) contat_ws (convert to string and use LIKE) 3) contat (convert to string and use LIKE)   Check the definitions in here : https://experienceleague.adobe.com/en/docs/experience-platform/query/sql/spark-sql-functions   Let me know ...

@AkramH Unfortunately this option not available at this point. We can achieve this by API's which may ease you little bit.   First API to get list of Fragments with filtering: https://developer.adobe.com/journey-optimizer-apis/references/content/#operation/getFragments Second API to create a package...

@amit360degreee Here is the sample query to work with.   SELECT DISTINCT /* template contains AE._experience.customerJourneyManagement.entities.channelDetails.template, /* template contains raw message stored as json */ AE._experience.customerJourneyManagement.entities.journey.* /* ...

Hello @amit360degreee : Raw messages are stored in AJO Entity Dataset for SMS as well and delivery related information will be injected to AJO Message Feedback Event Dataset.   Let me know if you need more details and please mark this thread accordingly.   ~cheers, NN

Hello @Michael_Soprano Can you please elaborate your requirement? I am trying to understand if there is a race condition here.   ~cheers NN

Hello @SaurabhCh3,   This is totally feasible, you need to have a scheduled insert query(based on your need) to same audience for re-ingesting to have your lastQualificationTime updated. Sample Query : INSERT INTO Audience <<audience name>> SELECT <<business logic>> Once the audience is re-ingested...

Hello @trojan_horse were you able to consume the solution?

@trojan_horse: Here goes the solution for this use case. 1) Any interaction with email be it open, click and unsubscribe will log in to "AJO Email Tracking Experience Event Dataset" which in turn will be attached to your profile, you can verify your case by sending a email to your self and try to do...