Build relation between two dynamic attributes

[Manju_p]

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

[SumathiSomala]

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

[Manju_p]

Hi Sumathi, 

Thanks for the response. Below are the dynamic attribute details. 

Regards,
Manju

[SumathiSomala]

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

[SumathiSomala]

Use single select query like

select 'gts' as id union select 'prpc' as id

Use action string SHOW/HIDE

OR Try with datasets

[rushikeshvartak]

Change ENUM to single select query like

select 'gts' as id union select 'ming' as id