How to email Project Manager when a project task is updated

[mitzaka]

Hi SNC,

I have a case with Project Management - I want to set up a notification which will be sent to the Project Manager of a project, when a project task from that project is updated.

The issue is - when I try to setup a notification for the pm_project_task table, I cannot refer to the Project Manager field, as this field is from the pm_project table.

Another thing I want to do is - is there a way to add a field to the project task form, which shows the project they belong to. I think this would be very useful.

[Harish Murikina]

Use below code in your notification

<mail_script>

email.setFrom(current.parent.project_manager.email);

</mail_script>

Click below link for more details how to set from address

Scripting for Email Notifications - ServiceNow Wiki

[Anurag Tripathi]

Write a business rule on pm_project_task table

After

insert/update

in the script part use

var ev1 = current.parent.project_manager

gs.eventQueue('event', current, ev1, ev1);

and in the mail notification you can check the boxes to sent email to event parameter 1

[mitzaka]

Anurag Tripathi -I am not exactly sure I understood. You told me to create a business rule on pm_project_task and then setup a notification on that table, where the recipient would be the event creator? If so, I tried but for some reason it's not sending an email to the project manager.

[Anurag Tripathi]

can you use gs.infoMessage or gs.log to check that are you getting the sys_id of project manager in the br??

and in the Email Notification, along with the send to event createor, there are 2 more check boxes...parameter 1 and 2...check those also.

[Harish Murikina]

If you would like to send immiade parent project instead of project task use below code

For ex: PR00100-->PRJTASK00100-->PRJTASK00101-->PR00101-->PRJTASK00102-->PRJTASK00103

Fro mthe above example "getProject" can return "PR00101" so you can this project manager mail id and send to him

var project_id = getProject(current.task);

g_scratchpad.u_project_number = project_id;

function getProject(planned_task_number)

{

      var return_sys_id = '';

      var pl_task_number = planned_task_number;

      var gr = new GlideRecord('pm_project_task');

      gr.addQuery('sys_id', pl_task_number);

      gr.query();

      if(gr.next())

              {

              pl_task_number = gr.parent;

              if(gr.parent.sys_class_name == 'pm_project')

                      {

                      return_sys_id = pl_task_number;

                      return return_sys_id;

              }

              else

                      {

                      return_sys_id = getProject(pl_task_number);

              }

      }

      if(return_sys_id !='' || return_sys_id != 'undefined')

              {

              return return_sys_id;

      }

      else

              {

              return return_sys_id;

      }

}