08/04/2023 12:05 AM
Hi, I am currently working on user update rule where we need to trigger a user manager certification one week before the users enddate. How should I setup the configuration for this scenario?
Solved! Go to Solution.
08/04/2023 12:19 AM
Hi @Diksha10,
You can achieve it by 2 way.
1. Create detective update rule with condition datediff(a.enddate, curdate())=7 then add launch campaign as an action in the rule. Make sure to schedule detectiverulerun everyday once.
2. Create non-detective update rule with condition (##a.custompropertyXX is updated## and a.custompropertyXX='LaunchCampaign') and add launch campaign as an action in it. Create SAV4SAV with userimport xml and query which will update custompropertyXX with string "LaunchCampaign" for users whose enddate is still have 7 days.
08/04/2023 04:21 AM
Thank you. It worked.
08/04/2023 07:01 AM
As per best practice from Saviynt, it is better to use Approach 2 as suggested by @pmahalle