Dynamic attrbute value population based requestor attributes

[gwagh]

Hi Team,

We have a use case, If requestor cost center is = 'ABC'  then in the dynamic attribute Depertcode1 and Depertcode2 should be populate and if the requestor cost center is = 'XYZ' then in the attribute Depertcode3 and Depertcode4.

How we can define this ?

Thanks,

Gaurav

[PremMahadikar]

Hi @gwagh ,

You can achieve this by considering cost center as dynamic attribute.

Dynamic Attribute for costcenter:

Attribute Name	costcenter
Attribute Type	Single Select From SQL Query
Value	select costcenter ID from users where userkey=${requestor}
Default value	select costcenter ID from users where userkey=${requestor}
Editable	unchecked

Action String: 

SHOW###Depertcode1##ABC___SHOW###Depertcode2##ABC___HIDE###Depertcode3##ABC___HIDE###Depertcode4##ABC___SHOW###Depertcode4##XYZ___SHOW###Depertcode3##YYZ___HIDE###Depertcode2##XYZ___HIDE###Depertcode1##XYZ___

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

[rushikeshvartak]

You can use single select SQL query with default value sample

select costcenter as ID from users where userkey=${requestor}