Expand my Community achievements bar.

SOLVED

How to use data from a previous activity as a variable in a query in a next activity?

Avatar

Level 3

Hi community,

 

We'd like to know how can i use a data obtained from a previous activity as a variable in a following activity in a workflow?.

 

From delivery logs We obtain the profiles whose i sent an especific email, and in our ACS instance we have a custom resource called purchase orders related to profiles. To send a remarketing campaign we need to send an email to profiles with no purchase order after the the date we sent the first email. Until we hadn´t been able to pass the event date as parameter in the related purchase orders.

 

This is the workflow and configurations so far

 

olsalas711_0-1635880370572.png

 

1. We obtain the delivery logs

olsalas711_1-1635880445270.png

 

olsalas711_2-1635880472592.png

 

2. We reconciliate the profiles

olsalas711_3-1635880597381.png

 

3. We add purchase data

olsalas711_4-1635880667244.png

 

olsalas711_5-1635880701631.png

 

olsalas711_6-1635880740212.png

 

and this is how we try to filter the purchase orders after the first email was sent.

 

olsalas711_7-1635881061795.png

 

Thanks in advance for any help you can give us.

 

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

Do you see "Additional data" in the filter dialog?

This normally should include the reference you looked up in the Enrichment and then should be available for the filtering

 

Note: you may need to add Max(purchase Date) or similar in the enrichment step

View solution in original post

2 Replies

Avatar

Correct answer by
Employee Advisor

Do you see "Additional data" in the filter dialog?

This normally should include the reference you looked up in the Enrichment and then should be available for the filtering

 

Note: you may need to add Max(purchase Date) or similar in the enrichment step

Avatar

Administrator

Hi @olsalas711,

Were you able to resolve this query or do you still need more help here? Do let us know.

Thanks!



Sukrity Wadhwa