Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Multi select in Dynamic attribute

sk
Regular Contributor
Regular Contributor

Hello Team,

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

SriRanga_0-1714729418213.png

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.

7 REPLIES 7

PremMahadikar
Valued Contributor
Valued Contributor

Hi @sk ,

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
DA1RegionSELECT DISTINCT ATTRIBUTE3 AS ID FROM dataset_values WHERE datasetname = 'Regionmarket' ORDER BY ATTRIBUTE3 ASC
DA2MarketSELECT DISTINCT ATTRIBUTE2 AS ID FROM dataset_values WHERE datasetname = 'Regionmarket' and ATTRIBUTE3 in (${region}) ORDER BY ATTRIBUTE2 ASC
DA3GeoSELECT DISTINCT ATTRIBUTE1 AS ID FROM dataset_values WHERE datasetname = 'Regionmarket' and ATTRIBUTE2 in (${market}) ORDER BY ATTRIBUTE1 ASC
DA4CountrySELECT 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

PremMahadikar_0-1714731763980.png

 

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

sk
Regular Contributor
Regular Contributor

Hi @PremMahadikar , Thank you for the response

It was working fine. Thanks a lot

 

PremMahadikar
Valued Contributor
Valued Contributor

@sk ,

Perfect!

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

sk
Regular Contributor
Regular Contributor

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

SriRanga_0-1714997641130.png

 

PremMahadikar
Valued Contributor
Valued Contributor

@sk,

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

 

sk
Regular Contributor
Regular Contributor

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
Valued Contributor
Valued Contributor

@sk ,

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 -> valueAsia Pacific
ev.customproperty1 IN (${region})

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