Query for fetching entitlement type name in creation of dynamic attribute in Endpoint configuration

[sumit_morchhale]

I want to fetch the entitlement type from dynamic attribute from entitlement_types table. But query is not working.

Query:- "select entitlementname from entitlement_types"

This query is not returning entitlement type for respective endpoint.

Values Query:- "select entitlementname from entitlement_types"

Please suggest me query for fetching name entitlement types  associated with endpoint or should i add endpoint table with above query. Please let me know.

[AmitM]

HI @sumit_morchhale ,

select entitlementname as ID from entitlement_types where endpointkey =1.

If you dont want to use endpointkey then you can join it with endpoints table and use name.

But you need to hardcode key or name in you query.

Thanks,

Amit

If this answers your query, Please ACCEPT SOLUTION and give KUDOS.

[sumit_morchhale]

Hi Amit,

Still, It is not working.
Query:- "select entitlementname as ID from entitlement_types where endpointkey =1."

Please check the configuartion mentioned in above screenshot and let me know something is more required.

Thanks,
Sumit

[naveenss]

@sumit_morchhale  change the attribute type from ENUM to Single select from SQL Query.