Announcing the SAVIYNT KNOWLEDGE EXCHANGE unifying the Saviynt forums, documentation, training, and more in a single search tool across platforms. Click HERE to read the Announcement.

Issue in change password Query

saimeghana
Regular Contributor
Regular Contributor

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

 

10 REPLIES 10

avinashchhetri
Saviynt Employee
Saviynt Employee

@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 ?

 

 

Regards,
Avinash Chhetri

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

@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 ?

 

 

Regards,
Avinash Chhetri

saimeghana
Regular Contributor
Regular Contributor

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

Thanks,

Saimeghana

On preview does it showing results


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

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

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


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Do we have any other functions where we can compare the startdate and sysdate is lessthan 2 something like this.

saimeghana_0-1666179222989.png

only this error we can see in logs.

Thanks,

Saimeghana

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


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

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