Send email when a column value changes in database
I have a requirement where I need to monitor a status column in a database table which is getting updated by a 3rd party application.
Suppose if the status value is changed to "S00" in database, I want to monitor the status for 1 hour and if its still "S00", I need to call an activity in Pega to send an email.
How to implement this?
***Edited by Moderator Marije to add Capability tags***
Vodafone Shared Services India
IN
@KirtiG48 if you have updateDateTime property in table and 3rd party is updating that value, then may be you can write job scheduler to fetch records updated within last 1 hr and additional filter criteria as per your requirement.
You can also try to write DB trigger before update which will store column value in another backup column for comparision.
Regards,
Prashant N
Wipro
IN
@prashantn5424 Thanks for your response. The issue is that updateDateTime will be updated no matter which column value is getting changed. I just need to monitor 1 column.
Updated: 1 Jun 2022 7:00 EDT
Lint Group Ltd
IN
Hi @KirtiG48,
You can use declare on change to monitor a specific property (Status property) in Pega and write activity to queue it to the queue processor with a delay of 1 hr inside the declare on-change rule. In the queue processor activity, you can write logic to send emails by checking the current status and the status while queuing are the same or not.
Regards,
K Chandra Prakash.
Wipro
IN
@KChandraPrakash Declare on change will work when I am changing the property value from Pega. Here the value is changing in database by some third party application. So declare on change will not work in this case.