Project task overdue Notify

[major3]

i want to send a notification to project manager and resource who is working on the task,if the project task is over due for more than one day...and i have to send this notification daily till the project task is not completed or changed?     I don't know what is task overdue...is it planned end - actual end...please hel me out to acheive this..thanks in advance.

kellykaufmann

[arun_vydianatha]

What I understood by overdue is - the work hasn't started on the task yet. If work hasn't started on the task, state would be in pending/open or alternatively work_start is NULL.

It is not good to rely on Planned end date.   Our Planned end date field is kind of dynamic - when actual start date comes in we overwrite Planned end date as Actual start date + Planned duration.

In Jakarta we are introducing two new fields Original start date and Original end date, those are the original planned dates and are never modified, so in that you can rely on Original end date.

For time being do not rely on Planned end date.        

[major3]

Ok great arun, Now it is clear to me..but can we achieve it without writing the script...i mean only from condtion builder....

like current date is more than 1 day from start date AND state is one of OPEN /PENDING

My actual requirement is

As a project manager, I should be notified when a project task is overdue so that I may accurately track the timeline.

who will receive?

        - Assigned project manager

        - Assigned Resource for the task

what will trigger?

- 1 Day after task is scheduled to be completed

- Notifications should continue daily until task is either complete or due date has been changed

[arun_vydianatha · Accepted solution]

You can create a Scheduled report for this Schedule a report

Condition builder supports the above script

In Jakarta I would do what you are asking with this condition as shown below.

If you are in Istanbul - since you don't have Original end date - I would suggest you add a custom column original_end_date and copy end_date on to this column before task goes to WIP.

Here in the condition I am checking if End date was 1 day ago and task is still lying around as active (which means it has not closed).

[major3]

Thanks arun , but still in my requirement ...

what will trigger?

- 1 Day after task is         scheduled to be completed

- Notifications should continue daily until task is either complete or due date has been changed

i think for that i can't go with start date...it is asking me to send the design when the task is scheduled to be completed..anyways gr8 learning.

[arun_vydianatha]

Condition original end date is relative 1 day ago will trigger the tasks - which are active and which were supposed to end one day ago.