Multi select in Dynamic attribute

[saiKrishna]

Hello Team,

We have a requirement where we have 4 attributes (Region, Market, Geo and country)

If user selects EMEA region then (NWE, CE,SE) should populate under Market and same follows for both Geo and country. To achieve this we have created dataset and it was working as expected.

Now the requirement is it should be multi select 

if users selects both EMEA and Americas under region then (NWE,CE,SE and LA,NA) should populate under Market 

all the four attributes should be multi select ,

How can we achieve this.

[PremMahadikar · Accepted solution]

Hi @saiKrishna ,

You have 4 dynamic attributes. Please use the below configuration in your DA's:

• Make all DA's type: Multiple Select From SQL Query
• Use the below query

DA1	Region	SELECT DISTINCT ATTRIBUTE3 AS ID FROM dataset_values WHERE datasetname = 'Regionmarket' ORDER BY ATTRIBUTE3 ASC
DA2	Market	SELECT DISTINCT ATTRIBUTE2 AS ID FROM dataset_values WHERE datasetname = 'Regionmarket' and ATTRIBUTE3 in (${region}) ORDER BY ATTRIBUTE2 ASC
DA3	Geo	SELECT DISTINCT ATTRIBUTE1 AS ID FROM dataset_values WHERE datasetname = 'Regionmarket' and ATTRIBUTE2 in (${market}) ORDER BY ATTRIBUTE1 ASC
DA4	Country	SELECT DISTINCT ATTRIBUTE4 AS ID FROM dataset_values WHERE datasetname = 'Regionmarket' and ATTRIBUTE1 in (${geo}) ORDER BY ATTRIBUTE4 ASC

Note: Assuming your country values are in attribute4 of dataset table

if this answers your question, please consider selection Accept As Solution and hit Kudos

[saiKrishna]

Hi @PremMahadikar , Thank you for the response

It was working fine. Thanks a lot

[PremMahadikar]

@saiKrishna ,

Perfect!

Please Accept as Solution and hit Kudos if this answers you query!

[saiKrishna]

Hi @PremMahadikar ,

The above approach is working fine but when we select 2 regions , then the entitlements were not appearing . Am I missing anything here? Please advise

[PremMahadikar]

@saiKrishna,

Are you using 'Config for Requestable Entitlement in ARS' at endpoint -> Entitlement type?

[saiKrishna]

Hi @PremMahadikar ,

We are using the below config in  ;Config for Requestable Entitlement in ARS' at endpoint

('${region}'='Americas' and ev.customproperty1='1') or ('${region}'='EMEA' and ev.customproperty1='2') or ('${region}'='Asia Pacific' and ev.customproperty1='3')

[PremMahadikar]

@saiKrishna ,

Can you save Americas, EMEA, Asia Pacific in respective entitlement CP1 and just try the below code:

• ENT1 -> CP1 -> value: Americas
• ENT2 -> CP1 -> value: EMEA
• ENT3 -> CP1 -> value: Asia Pacific

ev.customproperty1 IN (${region})

 if this answers your question, please consider selection Accept As Solution and hit Kudos