How to find the concerned flag get updated of the day
System needs to browse all contracts in Pega to fetch the flag information and put those in an csv file on every working day at 5pm CST. Contracts meet the below criteria will be selected for the flag send back, the concerned flag get updated of the day, which is
• Either flag value is set from “True” to “False”, or
• Flag value is set from “False” to “True”
• Flag status update time = Today
The particular table having around 30 columns . How can I find the particular column is updated or not?
I think you need to use a separate property , say FlagUpdateDateTime . The value for this can be set whenever the flag gets updated via a declare trigger ( with Saved and one of these properties was modified ) enabled.
Then , in order to check whether it is updated or not, simply use this FlagUpdateDateTime filed as a filter to check whether it is equal to today or not.