and more in a single search tool across platforms. Read the announcement here. |
11/12/2023 04:30 AM
Hi Team,
We have table with three columns username, role and region. When the user selects the role all the regions are getting displayed as below. looking forward to build relation between role and region.
ROLE | REGION |
gtsadmin | gts |
gtsuser | gts |
opuadmin | mlng |
opuadmin | mrcsb |
opuadmin | pcmtbe |
opuadmin | pgb |
opuadmin | prpc |
opuuser | mlng |
opuuser | mrcsb |
opuuser | pcmtbe |
opuuser | pgb |
opuuser | prpc |
Thanks,
Manju
11/12/2023 04:43 AM - edited 11/12/2023 04:57 AM
@Manju_p Are you using datasets for the data?if yes please refer sample queries
DA1:
select distinct attribute1 as ID from dataset_values where dataset_values.datasetname ='<dataset_name>'
DA2:
select distinct attribute2 as ID from dataset_values where dataset_values.datasetname ='<dataset_name>' and attribute1 = ${DA1}
also please the queries used in dynamic attributes and other details.
If this reply answered your question, please Accept it As Solution to help others who may have a similar problem.
11/12/2023 03:40 PM
Hi Sumathi,
Thanks for the response. Below are the dynamic attribute details.
Regards,
Manju
11/13/2023 04:45 AM
@Manju_p ENUM will not create a relationship. you can build relationship with dataset for DynRegion.
From where you will get values for DynRegion and are those static?
11/13/2023 05:05 PM
Use single select query like
select 'gts' as id union select 'prpc' as id
Use action string SHOW/HIDE
OR Try with datasets
11/13/2023 10:54 AM
Change ENUM to single select query like
select 'gts' as id union select 'ming' as id