dynamic Attribute

[Rajatlm10]

Hi ,

i need to non editable value in child DA based on the parent attribute. 

i am using the below query to achieve the same but its not working. 

SELECT id when ${RoleName}='Expense Processor' then 'EXP_PROCESSOR' end as id

union

SELECT id when ${RoleName}='Expense Proxy Logon' then 'EXP_PROXY_USER' end as id

Can anyone help me on this ?

[PremMahadikar]

Hi @Rajatlm10 ,

The below is the right syntax:

select case when ${RoleName}='Expense Processor' then 'EXP_PROCESSOR' end as id union select case when ${RoleName}='Expense Proxy Logon' then 'EXP_PROXY_USER' end as id

One example:

Query: select case when ${country}='United States' then 'US-001' when ${country}='Albania' then 'AL-008' end as id union select case when ${country}='United States' then 'US-002' when ${country}='Albania' then 'AL-009' end as id

If this helps your question, please consider selecting Accept As Solution and hit Kudos

[rushikeshvartak]

SELECT
CASE
WHEN ${RoleName} = 'Expense Processor' THEN 'EXP_PROCESSOR'
WHEN ${RoleName} = 'Expense Proxy Logon' THEN 'EXP_PROXY_USER'
ELSE NULL
END AS id