Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

user notification from PPM reports

Highlighted
Semenov Alexand
Esteemed 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
Regular Collector

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.
//Add this to "OnDomLoad" event