Update rule not triggering when user terminated from Campaign

[harishyara]

Team - We have a use case where if any user is terminated from Campaign (User Manager) we need to trigger an update rule which will deprovision all the user access.

For this I have configured below update rule. After user is terminated from campaign this rule is not getting triggered. Please note that I tried with below conditions using two trigger types Update from Import and Update from UI but rule is not getting triggered.  

is there anything I am missing here ?

[rushikeshvartak]

• Did you checked logs.
• Please share logs

[harishyara]

Hi @rushikeshvartak  - Below is the log snippet I could find. Please check.

[rushikeshvartak]

You have issue with configuration. Please share full logs in text format and change rule to advanced configuration

a,statuskey=0 AND a.comments like '%terminated through Certifications%' AND (##a.comments isupdated##)

[NM]

Hi @harishyara try once using advance query.

[harishyara]

@rushikeshvartak - What is the trigger type I can configure ? is it update from Import or  Update from UI ?

[rushikeshvartak]

API for testing you can use UI

[harishyara]

@rushikeshvartak  - I tried with Avd config with trigger type as Updated from UI and also Updated from Import but both of them are not working, do I need to try with Update from API as well ?

[rushikeshvartak]

• Share logs in text file when you have done from UI

[dgandhi]

Did you check if user comments is getting updated? Can you try using advance query and if it works?

[harishyara]

Hello @rushikeshvartak - here is the log

hql userupdate --select a.id from Users a where a.id=30 AND (( 1 = 1 ) AND (  a.comments like '%terminated through Certification%' ) AND   1=1 )

hql userupdate --select a.id from Users a where a.id=30 AND (( 1 = 1 ) AND (  a.comments like '%terminated through Certification%' ) AND   1=1 ) executed

[harishyara]

@dgandhi - Yes, I also tried same comments (like Users are being terminated through Certification -#####101010#####[Test_Campaign - 10000 (Test User)] on -Mon Aug 26 14:18:19 UTC 2024) from UI maually from User Details, update rule is triggering but when I terminate user from campaign it's not triggering

[Amit_Malik]

Hi @harishyara ,

1) create a rule that triggers through API, Trigger type is API. Use advance config

  a.comments like '%terminated through Certification%' AND (##a.comments isupdated##)

2) update a user using Saviynt REST API, updateuser

3) check if rule runs 

4) check if same works with campaign, if not, raise a ticket with Saviynt

Thanks,

Amit

If this answer your query, please ACCEPT SOLUTION.

[rushikeshvartak]

Please share full logs in text file

[harishyara]

Hi @rushikeshvartak  - I could find below logs.

hql userupdate --select a.id from Users a where a.id=30 AND (( 1 = 1 ) AND ( a.comments like '%terminated through Certification%' ) AND 1=1 )
hql userupdate --select a.id from Users a where a.id=30 AND (( 1 = 1 ) AND ( a.comments like '%terminated through Certification%' ) AND 1=1 ) executed

[rushikeshvartak]

• Share screenshot of comments property at user level

[harishyara]

Please find below screenshot.

[rushikeshvartak]

Does it works if you update from UI

[harishyara]

It worked when I update comments from UI manually, having update rule with trigger type as : Trigger when user is updated from UI

[rushikeshvartak]

It will be update query when updated from campaign hence it seems u will not be able to achieve this