topic Re: Condition in Scheduler to send and email. in Adobe Campaign Classic Questions

Condition in Scheduler to send and email.

Yamila1981 — Fri, 19 Aug 2022 18:46:56 GMT

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

Re: Condition in Scheduler to send and email.

Marcel_Szimonisz — Sun, 21 Aug 2022 03:38:17 GMT

Hello ,

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

Re: Condition in Scheduler to send and email.

_Shubham_Goyal_ — Tue, 23 Aug 2022 07:46:32 GMT

Hi ,

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

Re: Condition in Scheduler to send and email.

Yamila1981 — Wed, 24 Aug 2022 14:50:21 GMT

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

Re: Condition in Scheduler to send and email.

Yamila1981 — Wed, 24 Aug 2022 14:51:56 GMT

Hello _Shubham_Goyal_!!!

Cheers