Click HERE to see how Saviynt Intelligence is transforming the industry. |
07/12/2024 12:27 AM
Hi Team,
I have an requirement that for User attribute lets CP 10 we will update the value in CP10 as End Date (20-07-2024) as an example.
Now using user update rule if i want to disable the account if CP10 is updated and CP10 value matches the current date then the corresponding AD account will be disabled
How to put the query in condition checking (What is the query)
Thanks
Arnab Pal
Solved! Go to Solution.
07/12/2024 01:01 AM
Hi @ARNAB86 use the condition like below. Use Advanced config under user update rules.
(##a.customproperty10 isupdated##) AND (a.customproperty10=curdate())
07/12/2024 01:38 AM
@ARNAB86 Requirment for UI update or Import update ?
you need select proper type Trigger Actions when,as per screenshot and you can write below approch also it work,
07/12/2024 01:48 AM - edited 07/12/2024 01:50 AM
This is UI update and also will it accept in this format and validate with currentdate
CP10 = 12-07-204
Thanks
Arnab Pal
07/12/2024 02:20 AM
@ARNAB86 Use DATE_FORMAT(curdate(), '%d-%m-%Y')
07/12/2024 02:37 AM
07/12/2024 07:38 AM
(##a.customproperty10 isupdated##) AND (a.customproperty10=DATE_FORMAT(curdate(), '%d-%m-%Y'))