Populate Dynamic Attribute Value on the Application Form from Datasets

[nkashyap]

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.

[Saathvik]

@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.

[rushikeshvartak]

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 .

[nkashyap]

Hello Saathvik and Rushikesh,

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

Thanks for your time and suggestions.

[rushikeshvartak · Accepted solution]

Please share solution

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

[nkashyap]

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}