Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

If else block in workflow query

savuser17
Regular Contributor
Regular Contributor

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

 

4 REPLIES 4

rushikeshvartak
All-Star
All-Star

If value is changed then what ? Assign to whom ?


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

If value is changed then it goes to another if-else block for another check. If not changed, it goes to grant access block

Above tables are not exposed in if else block 


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

AmitM
Valued Contributor
Valued Contributor

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

AmitM_0-1719173626718.png

You would, hopefully, be able to achieve it after that.

 

Thanks,

Amit

If this answers your query, Please ACCEPT SOLUTION and give KUDOS.