Project and Portfolio Management Practitioners Forum
cancel

user notification from PPM reports

Highlighted
Semenov Alexand
Acclaimed Contributor.

user notification from PPM reports

Good Day ALL.
I need help for solve interest task.
Task: need send mail to users who mails receive from SQL.
This e-mail list has various values.
For example I need send message to assigned users from request if in this requests current date > control date field.
I think it possible with help PPM reports but don’t know how to do it.
My be anybody do something similar.

Many tanks in advice!!!!
1 REPLY
Vibhor Dwivedi
Super Contributor.

Re: user notification from PPM reports

you can use a SQL function to send a mail through database...

you can send a mail on different events
Write a database trigger to trigger notification when a field value changes.
Call function in execution step.
Call function in request rule.