User Update Rule : Grouping multiple conditions

[Community_User]

Originally posted on February 7 2020 at 12:31 UTC

This is a question about how to configure multiple conditions using AND and OR.

I want to configure the following condition:

WHEN field_1 IS UPDATED
AND field_1 IS NOT NULL

OR field_2 IS UPDATED
AND field_2 IS NOT NULL

OR field_3 IS UPDATED
AND field_3 IS NOT NULL

AND users.username = "User1"

But this rule fired for every user in my Saviynt instance.

How can I group my conditions so that I can group the 2 conditions for each field and do the OR between those groups?

e.g.

( field_1 IS UPDATED AND field_1 IS NOT NULL )
OR
( field_2 IS UPDATED AND field_2 IS NOT NULL )
b
( field_3 IS UPDATED AND field_3 IS NOT NULL )
AND users.username = "User1"

[Community_User]

Originally posted on February 7 2020 at 12:33 UTC

I know I can configure separate User Update rules for each field, but just wanted to know if there is a way to configure advanced multiple conditions.

[Community_User]

Originally posted on February 11 2020 at 04:24 UTC

Hi Anand,

You canfigure multiple conditions using advance configure. Below are few examples:

1--> (##a.jobcode isupdated##) AND a.statuskey = 1 AND a.customproperty3 = 'Yes' AND a.customproperty4 = 'Yes' AND a.customproperty5 = 'SSO' AND a.email is null

2--> a.statuskey=1 AND ((##a.middlename isupdated##) OR (##a.street isupdated##) OR (##a.regioncode isupdated##) OR (##a.city isupdated##) OR (##a.country isupdated##) OR (##a.manager isupdated##))

Thanks

Ajay

[Community_User · Accepted solution]

Originally posted on February 11 2020 at 18:47 UTC

Thank you Ajay.