Unable to see dynamic attribute list on ARS page with simple query

[Bhargavi3]

Hi Team,

Our requirement is to pass role code(Entitlement ID) through create account json. So, we are creating a dynamic attribute where we can see all the list of role codes where user can select one and that dynamic attribute will be mapped with the attribute in Create Account json. The below query we are using to fetch the data, it is working in data analyzer but it is not getting reflected in ARS page.

select entitlementid from entitlement_values where ENTITLEMENTTYPEKEY=405 

we have 108 entitlements where user should select one.

Could someone help us to resolve this issue.

Regards,

Bhargavi Padaraju.

[rushikeshvartak]

select entitlementid  as id from entitlement_values where ENTITLEMENTTYPEKEY=405 

also select editable checkbox

[Raghu]

@Bhargavi3  try below query

select entitlementid as ID from entitlement_values where ENTITLEMENTTYPEKEY in (405)

[pmahalle]

Hi @Bhargavi3 Update the query as below and check the editable check box in your dynamic attribute check once. In case your entitlementid is not readable you use second query to show both entitlementid as well as entitlement_value in your dropdown

1. select entitlementid as id from entitlement_values where ENTITLEMENTTYPEKEY=405 

2. select entitlementid as id, entitlement_value as inlinedescription from entitlement_values where ENTITLEMENTTYPEKEY=405 

[Bhargavi3 · Accepted solution]

Thanks for all your replies.
It is working now. We have used distinct key and it worked.

select distinct entitlementid from entitlement_values where ENTITLEMENTTYPEKEY=405;

Thanks,

Bhargavi Padaraju.

[pmahalle]

@Bhargavi3  Great. Mark the solution and close the thread.