Click HERE to see how Saviynt Intelligence is transforming the industry. |
05/14/2024 06:04 AM - edited 05/14/2024 06:05 AM
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.
Solved! Go to Solution.
05/14/2024 06:25 AM
@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.
05/14/2024 08:56 PM
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 .
05/15/2024 07:48 AM
Hello Saathvik and Rushikesh,
I have figured this out by modifying the query and it started working.
Thanks for your time and suggestions.
05/15/2024 07:45 PM
Please share solution
Please click the 'Accept As Solution' button on the reply (or replies) that best answered your original question.
05/16/2024 04:05 AM - edited 05/16/2024 04:05 AM
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}