10/17/2022 04:22 AM
We have an issue when the email attribute is null then change password task should create and email should generate for manager, we are using the user update rule
Rule name- Test_email
((##a.email isupdated##) AND a.statuskey='1') AND datediff(curdate(),a.startdate)<3
Please help us to solve this issue.
10/17/2022 07:55 AM
Please elaborate your use case. What you have explained and the rule that you have written is not making much sense to me.
What attribute is getting updated ? Where is the check for null/blank email in your rule ?
10/17/2022 11:01 PM
We are trying to create the change password task when user has a null email attribute.
tried with this Advance query not worked: ((##a.email isupdated##) AND a.statuskey='1') AND email is NULL
trying with ((##a.email isupdated##) AND a.statuskey='1') AND datediff(a.sysdate(),a.startdate)<3 when we tried with datediff rule is not triggered.
10/19/2022 07:18 AM
So the requirement is that you need to create a change password task when the user has a null email attribute. You are trying to do this via the UserUpdate Rule.
What is the trigger point ? What changes in the user profile is supposed to trigger this rule ?
10/18/2022 12:30 AM - edited 10/18/2022 02:47 AM
Either can we use datediff() in advance queries in user update rule?
10/18/2022 06:26 AM
10/18/2022 11:17 PM
When we use this ((##a.email isupdated##) AND a.statuskey='1') AND datediff(a.sysdate(),a.startdate)<3 Advance query rules is not triggered.
10/19/2022 04:15 AM
10/19/2022 04:34 AM
Do we have any other functions where we can compare the startdate and sysdate is lessthan 2 something like this.
only this error we can see in logs.
10/19/2022 04:40 AM
10/19/2022 06:29 AM
Even this did not work. Can we use these functions in User Update Rule as i don't see anything related to this in documentation.