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

Populate Dynamic Attribute Value on the Application Form from Datasets

nkashyap
New Contributor II
New Contributor II

Issue : Attrbute Value from Dataset is not populating om the Application Form Using Dynamic Attrbute.

Details: Hello Team,

We have created Application Form Using Dynamic Attribute and Populating the Attribute Value from created datasets using SQL query.

Example:
Dataset Name:Dataset_Test

MODULE,TEAMMEMBERACCESS,AGENT1,AGENT2,LOCATION

Module Team Member Access Agent1 Agent2 Location
Module1 Team Member Access1 Yes Yes All
Module1 Team Member Access2 No No All
Module2 Team Member Access3 No No All
Module2 Team Member Access4 Yes Yes All
Module3 Team Member Access5 No No All
Module3 Team Member Access6 Yes Yes All
Module4 Team Member Access7 Yes Yes All
Module5 Team Member Access8 Yes Yes All
Module6 Team Member Access9 Yes Yes All
Module7 Team Member Access10 Yes No All
Module8 Team Member Access11 Yes No None
Module9 Team Member Access12 Yes Yes All


Attribute Config Sample:

MODULE,TEAMMEMBERACCESS,AGENT1,AGENT2,LOCATION

Below query is working to return the value for attribute2

select distinct attribute2 as Id from dataset_values e where e.datasetname='Dataset_Test' and e.attribute1 = ${MODULE}

But when adding one more AND condition in the query to return the value for attribute3, then its not working.

select distinct attribute3 as Id from dataset_values e where e.datasetname='Dataset_Test' and e.attribute1 = ${MODULE} and e.attribute2 = ${TEAMMEMBERACCESS}


Please help to address this query issue.

5 REPLIES 5

Saathvik
All-Star
All-Star

@nkashyap : Please share your Dynamic attributes configuration, Also MODULE and TEAMMEMBERACCESS are also dynamic attributes if so please share the configuration for them as well.


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.

rushikeshvartak
All-Star
All-Star

Could you kindly provide a detailed snapshot of the information extracted from the logs, encompassing errors and other pertinent functionality details encountered during the execution of this process? Your assistance in furnishing this information would greatly aid in the analysis and resolution of any issues .


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

nkashyap
New Contributor II
New Contributor II

Hello Saathvik and Rushikesh,

I have figured this out by modifying the query and it started working.

Thanks for your time and suggestions.

Please share solution

Please click the 'Accept As Solution' button on the reply (or replies) that best answered your original question.


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

nkashyap
New Contributor II
New Contributor II

Hello Rushikesh,

I have removed "and" condition for module from where clause which was not required that solved the issue.

select distinct attribute3 as Id from dataset_values e where e.datasetname='Dataset_Test' and e.attribute1 = ${MODULE} and e.attribute2 = ${TEAMMEMBERACCESS}