If else block in workflow query

[savuser17]

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

[rushikeshvartak]

If value is changed then what ? Assign to whom ?

[savuser17]

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

[rushikeshvartak · Accepted solution]

Above tables are not exposed in if else block 

[Amit_Malik · Accepted solution]

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.