User update rule to send email to manager

[asharma]

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);

[asharma]

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##);

[Abhishek0406]

a.statuskey=0 AND a.employeeType in ('Third Party','ABC-A') AND datediff(a.enddate,now()) = 0 AND (##a.statuskey isupdated##)

Try this one

[asharma]

what does this query mean?

[Abhishek0406]

a.statuskey=0 AND a.employeeType in ('Third Party','ABC-A') AND datediff(a.enddate,now()) = 14 AND (##a.statuskey isupdated##)

[asharma]

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.

[NM]

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.

[asharma]

Trying but it says invalid condition. I am now trying below.

a.employeeType in ('Third Party','ABC-A') AND datediff(a.enddate,now()) = 14;

[NM]

Hi @asharma , semicolon is not required.

[rushikeshvartak · Accepted solution]

a.employeeType in ('Third Party','ABC-A') AND datediff(a.enddate,now()) = 14

[asharma]

This works, thankyou

[asharma]

It is working in data analyzer if i try individually.