Click HERE to see how Saviynt Intelligence is transforming the industry. |
08/22/2024 02:08 AM
Hi Team,
I want to send user's manager email notification of third party users where enddate of third party user is after 14 days. I tried below query and it is not working.
Users.statuskey=0 AND Users.employeeType in ('Third Party','ABC-A') AND DATE_SUB(Users.enddate, INTERVAL 14 day) = CURDATE() AND(Users.statuskey isupdated);
Solved! Go to Solution.
08/22/2024 02:12 AM
in advance config it is
a.statuskey=0 AND a.employeeType in ('Third Party','AGP-A') AND DATE_SUB(a.enddate, INTERVAL 14 day) = CURDATE() AND(##a.statuskey isupdated##);
08/22/2024 02:19 AM
a.statuskey=0 AND a.employeeType in ('Third Party','ABC-A') AND datediff(a.enddate,now()) = 0 AND (##a.statuskey isupdated##)
Try this one
08/22/2024 02:54 AM
what does this query mean?
08/22/2024 05:18 AM
a.statuskey=0 AND a.employeeType in ('Third Party','ABC-A') AND datediff(a.enddate,now()) = 14 AND (##a.statuskey isupdated##)
08/22/2024 03:18 AM
Also, this use case says third party users and those are created through UI so is there a way where we can check or schedule this rule as detective because that will not gona update any attribute before 14 days of enddate.
08/22/2024 05:25 AM
Hi @asharma , yes you can make the rule detective .. you will see an option retrofit detective in user update rule.
You have to schedule detective rule job which detect the user and send an email.
08/22/2024 05:40 AM
Trying but it says invalid condition. I am now trying below.
a.employeeType in ('Third Party','ABC-A') AND datediff(a.enddate,now()) = 14;
08/22/2024 05:42 AM
Hi @asharma , semicolon is not required.
08/22/2024 05:44 AM
a.employeeType in ('Third Party','ABC-A') AND datediff(a.enddate,now()) = 14
08/23/2024 07:55 AM
This works, thankyou
08/22/2024 02:16 AM
It is working in data analyzer if i try individually.