Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

How to get Multiselect Dynamic attribute values in Create account JSON in DB Connector

Rajesh_IAM
Regular Contributor
Regular Contributor

Hi Everyone,

I am working on DB application integration with Saviynt. For this application, have configured dynamic attributes Region, Country and Country code.  country depend on Region and countrycode depend on country DA. 

Issue 1:

For example: If user select "Europe" in Region DA then user can able select multiple countries in Country DA related to Europe Region. Based on Country DA value, countrycode DA should display respective country code values. But when I am selecting multiple values in Country DA, respective country code values are not displaying in countrycode DA (showing blank values). What should I do if end user can able see multiple country code values in countrycode DA if they select multiple country vales in Country DA.?

Country code DA SQL Query: SELECT distinct ATTRIBUTE3 as id FROM DATASET_VALUES WHERE DATASETNAME like 'TestLMSGeography' and ATTRIBUTE4 in ${Country_Name}

Issue 2:  If countrycode DA contains single value then I used insert query to insert values to DB.
{
"Groups": "insert into [xxxxx].[xxxx] (ID,CountryCode,OrganizationName,OrganizationID,GroupName,GroupID,TagName,TagId) values ('${user.username}','${Country_Code}','${Org_Name}','${Org_ID}','${task.entitlement_valueKey.entitlement_value}','${task.entitlement_valueKey.customproperty2}','${Tag_Name}','${Tag_Id}');"
}
But if countrycode DA contains multiple selected values then how can I get countrycode DA multiple values and how can I insert those multiple values into DB.?

Please review and suggest me for issue resolution.

 

 

3 REPLIES 3

rushikeshvartak
All-Star
All-Star

Share logs


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

Hi @rushikeshvartak  Attached logs.

Rajesh_IAM_0-1709190333075.png

 

Rajesh_IAM
Regular Contributor
Regular Contributor

 

There is mistake in mySQL query and Issue got resolved by myself.