Send notification to the Requested for and the abc group 30 days before the Duration date is reached

Samiksha2 · ‎08-18-2023

Hi All,

I have created a date field in the catalog form.

lets say I put duration as 12/31/2024.

30 days before the Duration date is reached, we have to notify requested for and "abc" group that your ticket is expiring.

Please help in this.

Thanks,

Samiksha

Community Alums · ‎08-21-2023

Hello @Samiksha2 ,

In When to send of notification Add Filter Condition :

Duration(ur date field) relative after 30 Days from now.

AND

Duration(ur date field) relative before 31 Days from now.

query:durationRELATIVEGT@dayofweek@ahead@30^due_dateRELATIVELT@dayofweek@ahead@31

@Samiksha2 , Please mark my answer as "Accept as Solution" and "Helpfuls." If it works for you.

Thank You!

View solution in original post

Samiksha2 · ‎08-21-2023

Hi @Community Alums ,

For testing I have changed the days as 1 and 2. It was supposed to trigger today. But I checked email didn't triggered.

Is anything I am missing?

Thanks,

Samiksha

Community Alums · ‎08-21-2023

Hello @Samiksha2 ,

May be due to the time zone of the instance. When you select the date, hover over that duration field and check if it is showing 24 hours from now or not.

Samiksha2 · ‎08-21-2023

Hi @Community Alums ,

My instance is taking US/ Central time zone. Right now its around 1 am. I checked the given query in sc_req_item. No data is showing.

Community Alums · ‎08-21-2023

@Samiksha2 , when u select duration date in the form on that field hover over and check if it is showing 24 hours from now or not.

Samiksha2 · ‎08-21-2023

Nothing is showing when I hover on Duration Exception variable in the catalog form

I am not sure hover will work on catalog form. If I add tooltip then only hover will work.