Dynamic Attribute values from different endpoints

[VisveswaraReddy]

Hi,

I need to populate values into Dynamic attribute from another endpoint entitlements, if we can populate how we can? or can we populate with SQL query.

[PremMahadikar]

Hi @VisveswaraReddy ,

Yes, you can populate in DA using 'Single Select from SQL Query' or 'Multiple Select from SQL Query'

Sample Code below:

select ev.ENTITLEMENT_VALUE as id from entitlement_types et inner join endpoints e on et.ENDPOINTKEY=e.ENDPOINTKEY inner join entitlement_values ev  on et.ENTITLEMENTTYPEKEY=ev.ENTITLEMENTTYPEKEY where e.ENDPOINTNAME=<NAME OF THE ENDPOINT>

Note: DA will not generate any task. 

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

[rushikeshvartak]

• Create new Dynamic attribute under Endpoint with below configuration and query
• Query : select ev.entitlement_value as id,ev.displayname as inlinedescription
  from entitlement_types et
  inner join endpoints ep on et.endpointkey = ep.endpointkey
  inner join entitlement_values ev on et.entitlementtypekey = ev.entitlementtypekey
  where ep.endpointname = 'AnotherEndpointName'
•