Hi,
I tried several options but I either get an error or all the data are not displayed from the dropdown menu.
I have a CDD element in a table overlapping with following concat
(SELECT activity_name FROM activities WHERE id = {thistable}.activity_name)
{thistable} (intemgroup1 table name) is a relational table containing IDs of the other tables.
Project Activities Subactivities
1 1 1
1 1 2
2 1 1
etc
So in the dropdown list I get all the data related based on the watch field which is project. so I get the following dropdown:
Project 1
Activities dropdown list 1,1,2,2,2,2,3,3,3,3
(with the concat in the dropdown list names are displayed not the ids)
I want to display only one value of the activity not all the options.
The last thing I tried is below but it displays empty dropdown list under activities.
I must be missing something and if anyone had similar issue I appreciate your help.
In where clause under CDD element:
(SELECT DISTINCT activity_name from intemgroup1)
Thanks
Alex
I tried several options but I either get an error or all the data are not displayed from the dropdown menu.
I have a CDD element in a table overlapping with following concat
(SELECT activity_name FROM activities WHERE id = {thistable}.activity_name)
{thistable} (intemgroup1 table name) is a relational table containing IDs of the other tables.
Project Activities Subactivities
1 1 1
1 1 2
2 1 1
etc
So in the dropdown list I get all the data related based on the watch field which is project. so I get the following dropdown:
Project 1
Activities dropdown list 1,1,2,2,2,2,3,3,3,3
(with the concat in the dropdown list names are displayed not the ids)
I want to display only one value of the activity not all the options.
The last thing I tried is below but it displays empty dropdown list under activities.
I must be missing something and if anyone had similar issue I appreciate your help.
In where clause under CDD element:
(SELECT DISTINCT activity_name from intemgroup1)
Thanks
Alex