Agile Approval Notification Frequency
Currently out of box Agile 9.3.1.2 sends approval notifications based on Reminder Period but they do not continue to send until the change order is actually approved. I’ve looked for a frequency setting with no luck. A PX requires a trigger and there isn’t really a trigger. Anyone have ideas or suggestions?
Hi JanB,
Can you explain what you have done.
I also needed to do same thing, When escalation period expired then needed to send notification mail to each user’s whose approval is awaiting everyday till he or she is not approve the same.
Thanks
Priyanka
I havent spent much time on this, rather I wanted to echo Ramesh’s approach with a different spin. I believe that all you need to do is hit the signoff table for rows that have a status of 0 (awaiting approval) and are at least a day old.
select u.first_name, u.last_name, u.email, c.change_number, s.last_upd
from signoff s
inner join change c on s.change_id=c.id
inner join agileuser u on s.user_assigned=u.id
where s.signoff_status=0 and s.last_upd < (sysdate-1)
order by s.change_id;
The “awaiting approval” status of 0 came from the list produced by the following command which I believe to be the signoff status’
select * from listentry where parentid=3876;
Again, due diligence is needed to test this fully – I am just playing with the data
Hi,
Apart from above solution, you could also configure a “Scheduled Event” and send out email notifications. This is what we have implemented.
