Click HERE to see how Saviynt Intelligence is transforming the industry. |
06/21/2024 05:53 AM
Hi,
We have a sort of complicated condition, where we want to check if there has been any change/update to a certain dynamic attribute. For this basically i want to check if this condition:
select SUBSTRING_INDEX(raa.ATTRIBUTE_VALUE, ' ', 1) as id from ARS_REQUESTS ar, request_Access ra,request_Access_attrs raa where ar.requestkey=ra.requestkey and ra.request_accesskey=raa.request_access_key and raa.attribute_name ='NewSupervisor' and ar.requestkey=${ARSREQUEST.id}
is equal to
current customproperty7 of the account
Does anyone have any ideas on how to execute this?
Thanks in advance
Solved! Go to Solution.
06/21/2024 05:55 AM
If value is changed then what ? Assign to whom ?
06/21/2024 06:09 AM
If value is changed then it goes to another if-else block for another check. If not changed, it goes to grant access block
06/21/2024 06:10 AM
Above tables are not exposed in if else block
06/23/2024 01:14 PM - edited 06/23/2024 01:14 PM
Hi @savuser17 ,
You can not achieve it right now but there have been an Idea accepted by Saviynt and is set for future release - https://ideas.saviynt.com/ideas/EIC-I-4506
You would, hopefully, be able to achieve it after that.
Thanks,
Amit
If this answers your query, Please ACCEPT SOLUTION and give KUDOS.