Good afternoon,
Can you help me with this need: I have to schedule a flow to run, for example, 5 days after the first delivery that is in an initial workflow has been sent. My idea is to put a scheduler that runs every day and then a condition to validate the eventdate of the first workflow if it occurred 5 days ago in order to send the second workflow.
Cheers
Solved! Go to Solution.
Views
Replies
Total Likes
Hello!!!
I found a way to get back to the contacts that were sent an email a few days ago. For example, contact those who received an email 5 days ago. So I start from the DeliveryLogs table and the EventDate field. What I do is the following: ToDate(EventDate) = ToDate(AddDays(GetDate, -5))
It is a little longer but it helped me to learn a little more. I also appreciate your suggestion that I will put into practice.
Cheers
Hello @Yamila1981 ,
you are not far from the result. Event date on workflow does not exists (last run or last modified but it may result in wrong results ) Query all deliveries instead, with contact day that is 5 days ago, with the use of dateOnly() on both contact date and 4 days ago expressions and run it daily
Marcel
Hello!!!
I found a way to get back to the contacts that were sent an email a few days ago. For example, contact those who received an email 5 days ago. So I start from the DeliveryLogs table and the EventDate field. What I do is the following: ToDate(EventDate) = ToDate(AddDays(GetDate, -5))
It is a little longer but it helped me to learn a little more. I also appreciate your suggestion that I will put into practice.
Cheers
Hi @Yamila1981 ,
You can make a query activity on xtk:workflow table which fetches workflows on basis of their last execution using date-time function "DaysAgo(5)". Now the DaysAgo() function returns the date and current time so you can wrap this function under DateOnly so the start time is 00:00.
Here is an query condition example you may use on your side to achieve this where this query will return all workflows that were processed on or after 00:00 5 days ago to 23:59.
Cheers,
Shubham
Hello _Shubham_Goyal_!!!
I found a way to get back to the contacts that were sent an email a few days ago. For example, contact those who received an email 5 days ago. So I start from the DeliveryLogs table and the EventDate field. What I do is the following: ToDate(EventDate) = ToDate(AddDays(GetDate, -5))
It is a little longer but it helped me to learn a little more. I also appreciate your suggestion that I will put into practice.
Cheers
Views
Replies
Total Likes
Views
Likes
Replies