Issue in change password Query

[saimeghana]

Hi Team,

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

Advance Query

((##a.email isupdated##) AND a.statuskey='1') AND datediff(curdate(),a.startdate)<3

Please help us to solve this issue.

Thanks,

Saimeghana

[avinashchhetri]

@saimeghana,

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 ?

[saimeghana]

Hi,

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.

Thanks,

saimeghana

[avinashchhetri]

@saimeghana,

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 ?

[saimeghana]

Either can we use datediff() in advance queries in user update rule?

Thanks,

Saimeghana

[rushikeshvartak]

On preview does it showing results

[saimeghana]

Hi,

When we use this ((##a.email isupdated##) AND a.statuskey='1') AND datediff(a.sysdate(),a.startdate)<3 Advance query rules is not triggered.

Thanks,

saimeghana

[rushikeshvartak]

Any error in logs. I have also tried datediff its giving error

[saimeghana]

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.

Thanks,

Saimeghana

[rushikeshvartak]

Refer https://forum.hibernate.org/viewtopic.php?p=2418380

[Nmaheshwari]

Hi Rushikesh,

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.

Thanks,

Nupur