By default load all ent and on select of dynamic attribute filter it ARS

[mbh_it2]

Hi All,

I have configured dynamic attribute with Single Select SQL Query: select 'NONE' as ID from entitlement_values where entitlement_values.status=1 UNION select distinct(entitlement_values.customproperty38) as ID from entitlement_values where entitlement_values.customproperty38 is not null ;

Default Value: 

select 'NONE' as ID from entitlement_values where status=1 limit 1;

Config for Requestable Entitlement in ARS 

( (ev.customproperty38='${ApplicationName}' AND ev.customproperty38 NOT IN('NONE')) OR (ev.customproperty38='NONE' AND ev.status=1))

here I want to by default load all entitlements in the table , either select NONE or say Select for dynamic attribute which is set to 

What action to perform when Parent attribute changes? Refresh
Here the CP38 values populates in dropdwon and when I change , the list changes accordingly but I want to load all ent by default which is not working.

Can some one let me know what change is Required.

Thanks

Mahesh

[rushikeshvartak]

Share logs and request form screenshots