How to send notification when due date reached

[chanikya]

Hi,

here i have one typical task that is send notification when Due date and time reached

Ex: in incident table i have 5 incidents

first ---> due date 26-04-2018 16:00:00      send notification exact at      26-04-2018 16:00:00

second--->due date 26-04-2018 13:20:00   send notification exact at   26-04-2018 13:20:00 

third--->due date 26-04-2018 18:00:00

fourth--->due date 26-04-2018 17:40:00

fifth--->due date 26-04-2018 16:10:00      all incidents are 26-04-2018 but time is different so is it possible to send notification based on Date & time   when it match with   current Date & Time......   

[Jace Benson]

They could all follow this same pattern.

Register an event for them.  Have the event trigger on insert/update when date is calculated/updated.  Have a script action verify the task still needs to notify the user, trigger a new copy of the event.  On the notification, verify the notification needs to be sent via the conditions. 

Or on each one configure the appropriate SLA's and calendars for each.  Perhaps PPM does notify daily but every other day, or at 25% to due date.  Both patterns would work.

[chanikya]

Hi,

 i have created B.Rule....So when this notification is going to be trigged..???

[Jace Benson]

You should be able to see the event on the `sysevent` table.  It won't have anything to do until you create a Notification that uses that event.

[chanikya]

i have created notifications  on incident table here as well now how can i trigger notifications ??

please suggest me i am getting confusion here...why means

Example: i have 5 incidents on 26-04-2018 with different timing... so may be if i does n't insert/update any incident records  for 3 days then on 25th, 26th, 27th days of notifications how can we trigger notification...... as per Exact time...

[Archana Reddy2 · Accepted solution]

Hi,

Try creating an insert/update Business Rule as below.

gs.eventQueueScheduled('event.name',current,gs.getUserID(),gs.getUserName(),current.u_due_field_name);

Before this, create an event with name as event.name and create a notification to be sent when this event fires.

In the notification, check Event parm 1 contains recipient and Event parm 2 contains recipient.

Hope this solves your issue.

Thanks,

Archana