DropDown Liste Databinding

Process Design
1

Hello,

I have 2 dropdown List , the first one contains a list of categories and the secon one contains subCategories.

How can I choose an item from the First List and then display only subcategories in the second one .

I have my tables in WFGEN Database and I created two global Lists.

Best Regads,
Sara .

2

Hi @sara,

Let’s say List 1 contains

Value
A
B
C

And List 2 contains:

Value Text
A 1
A 2
A 3
B 1
B 2
C 1

With the below setup of the dropdownlists:

image
image.png759×873 21.9 KB

If DroprownListBox1 = A --> DropdownListbox2 will contain 1,2 and 3
If DroprownListBox1 = B --> DropdownListbox2 will contain 1 and 2
If DroprownListBox1 = C --> DropdownListbox2 will contain 1

Hope this helps.

Eddy.

3

Hello,

Thanks for the reply Eddy.
Should I add an sql join to the the select request in the second dropdownlist?

Best Regards,
Sara

4

Hi @sara,

If your global lists are structured similarly to the example I provided, there is no need to perform a join.

If your databind requires complex queries. I recommend doing the databind in code behind.

You can retrieve the global list values in code like this:

WorkflowGen.My.Integration.GlobalLists gl = new WorkflowGen.My.Integration.GlobalLists();
System.Data.DataTable GLOBAL_LIST_DATA;
GLOBAL_LIST_DATA = gl.fetchList("GLOBAL_LIST_NAME", "Column1,Column2", "en-US", true);
foreach (System.Data.DataRow row in GLOBAL_LIST_DATA.Rows){
    ...
}

Eddy.

1 Like
5

Hi,
The problem that I have is that when I select the first Value in the first dropdown List I get the correct result but when I change the value I get the first result + the correct result . It seems Like the second Dropdwonlist is not cleared after choosing an item in the first one .

6

Hi @sara,

You can uncheck the option Append data bound items to avoid this behaviour.

Inkedb83e1d9420181e42f9238e2d23a01d9c12fa216e_LI
Inkedb83e1d9420181e42f9238e2d23a01d9c12fa216e_LI.jpg758×873 79.8 KB

Regards,
Eddy.

7

Hello,

Thanks Eddy.

Best Regards,

1 Like
8

Hi
I have two dropdowns in grid view first dropdown is x and second dropdown is y When I select a x from the global list, the form displays multiple dropdown entries with the same values (e.g., a, a and b, b, b, …) the values same in global list also but i want unique values based on x dropdown i have to fill y drop down. global list columns D, E, values a,1 and a, 2 and b,5 and b, 6 like that