Project task overdue Notify

major3 · ‎07-01-2017

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 · ‎07-04-2017

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).

View solution in original post

sachin_namjoshi · ‎07-01-2017

Hi,

create a scheduled job that triggers an event per record. Then have a notification sent out when this event is triggered. I would also record the last date the notification was sent out per record.

Recording the last date the notification would allow you to send a reminder every x days and if there was a problem with the scheduled job part way through you could re-run it and it would not re-send the notifications that had been sent out recently.

Regards,

Sachin

major3 · ‎07-02-2017

Thank you sachin for your prompt reply,But i am not getting when the project task is getting overdue..due you have any idea for this.

arun_vydianatha · ‎07-04-2017

Can we try a script something like this. Please note if you have custom states you will have replace the same. Here I am checking OOB Pending(-5) and Open(1) state to ascertain work is not started.

var today = new GlideDateTime();

today.addDays(-1);

var date = new GlideDateTime();

date.setDisplayValueInternal(today.getDate() + ' 08:00:00');

var gr = new GlideRecord('pm_project_task');

var qc = gr.addQuery('state', '-5');

qc.addOrCondition('state', '1');

gr.addQuery('start_date', '<', date);

gr.query();

while ( gr.next() ) {

gs.print('Delayed '+gr.number + ' ' + gr.getDisplayValue('start_date'));

}

Alternatively you can also remove state checks and do a simple

gr.addNullQuery('work_start');

major3 · ‎07-04-2017

Thanks arun,But i am not getting why the project task is overdue for state open /pending if start date is < date....i think it must be like that..if i put in condition////// Planned end date> current date...is this make sense??