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.
