Send Notification exactly 2 days before Due Date?

[jaisankar]

Hello Everyone,

I have request to send the Reminder Email for the Survey. The Survey Active period is 5 days( say for ex: if the survey is

generated on 12/08 the due date will be on 12/13)

The Reminder email should trigger on 12/11, which is two days before due date. I have tried the below query 

due_dateRELATIVEGT@dayofweek@ahead@3^state=ready in the Assessment Instance table.

But it is pulling all the records which is relative after 3 days. I just need the exact record count not all the records which is after 3 days? Say if 10 record has the due date on 12/13, i just need only the 10 records.

Can anyone help me out of this?

Regards,

Prem

[Ankur Bawiskar]

@jaisankar 

Refer below link where I have shared the approach for survey reminder email

Enhance it as per your need

How to send the reminder notification survey to the users who have not taken the survey.

Use this encoded Query

due_dateRELATIVEGT@dayofweek@ahead@2^due_dateRELATIVELT@dayofweek@ahead@3

Regards
Ankur

[jaisankar]

Hi Ankur,

Thanks for the Response!

I have already created the Event,Notification email and the Scheduled Job for the Same. But i'm facing the only issue that i'm not able to restrict the count for the particular day.

I have used your encoded query, it looks like below.

I'm not getting the Option on or after and on or before, and it is not giving the expected outcome. Any thoughts on this ?

Regards,

Prem

[jaisankar]

Hi Ankur,

Thanks for the Response!

I have already created the Event,Notification email and the Scheduled Job for the Same. But i'm facing the only issue that i'm not able to restrict the count for the particular day.

I have used your encoded query, it looks like below.

I'm not getting the Option on or after and on or before, and it is not giving the expected outcome. Any thoughts on this ?

Regards,

Prem

[Ankur Bawiskar]

Hi,

Query looks fine to me.

Did you find records matching that query in your assessment table

Regards
Ankur