Click HERE to see how Saviynt Intelligence is transforming the industry. |
02/08/2024 01:12 AM
I have 3 dynamic attributes DA1 ,DA2 and DA3 where DA3 is child to DA2 which is indeed a child to DA1.
If DA1 alone is selected I want Config for Requestable Entitlement in ARS as
ev.customproperty13 = '${DA1}' and ev.customproperty11 = '${DA1}'
if DA1 and DA2 is selected
ev.customproperty13 = '${DA1}' and ev.customproperty11 = '${DA2}'
if DA1 ,DA2 and DA3 is selected
ev.customproperty13 = '${DA1}' and ev.customproperty11 = '${DA3}'
Is there a way to achieve this condition? My customproperty11 value should be last selected dynamic attribute value.
02/11/2024 08:04 PM
ev.customproperty13 = '${DA1}' and ev.customproperty11 = case when '${DA2}' is null then '${DA1}' when when '${DA3}' is null then '${DA2}' else '${DA3}' end
02/11/2024 09:00 PM
Hi RushiKesh,
Tried your solution but the system throws me below error:
02/11/2024 09:30 PM
Your syntax is wrong please paste condition here
02/12/2024 02:13 AM
ev.customproperty11 = case
when '${dWell}' or '${dField}' is null then '${dOriginalOperator}'
when '${dWell_Wellbore}' is null then '${dWell}'
when '${dField_Well}' is null then '${dField}'
when '${dField_Wellbore}' is null then ${dField_Well}'
else '${dWell_Wellbore}' or '${dField_Wellbore}'
end
03/12/2024 07:28 PM
Please check and share logs when you updating entitlement type query