How to track the Due Date against the Current date and trigger the notification as soon as the Due Date is before the Current time

[arnoldzwane]

Hi Guys,

Could someone please advise on this one: I created an email notification on Private Task and this should be sent out to the "Assigned to" person   when the "Due date" has gone passed. My challenge is how do I get it to trigger without having to update the Private Task record. I need something that I can use to track the Due Date against the Current date and trigger the notification as soon as the Due Date is before the Current time.

Your assistance would be much appreciated.

Kind Regards

Arnold

[Mike Allen]

I use a business rule that writes to the sys_trigger table.   I just put a script in there to fire an event and then the email.

My colleague writes the event directly to the sys_event table with a future date, and a condition on the notification that says if active is false (or whatever) don't send.   That seems to work, as well.

[arnoldzwane]

Hi Mike,

Thank you very much for your advice; much appreciated. Since I 'm still battling with my scripting, I took the workflow route and it addressed my issue.

Thanks once again.

Kind Regards

Arnold

[srinivasthelu · Accepted solution]

Hi Arnload,

Workflow timer activity comes to great use in this scenario. You can select a field in the activity which holds the due date.

But how do you attach a workflow to the Task?

I would suggest you to create a new workflow and select the triggering conditions so that it will only get fired for the these tasks only.

Thanks

Srini

Mark this answer as helpful/correct if it does so.

[arnoldzwane]

Hi Srini,

Thank you very much for your advice. I just tried it and its working perfectly.

The only challenge I am currently faced with is applying this on the history tasks since I can't attached my workflow on the tasks that are already there. But I guess that's a compromise our client will have to make and be happy that going forward, their requirement is covered.

Thanks once again.

Kind Regards

Arnold