create a cascading dropdown in catalogue item

michaelantoun
Tera Contributor

Hi All,

 

I'm trying to create a dependency dropdown in a catalogue item, depending on the choice i make in the parent dropdown, i only want to see the corresponding data in child dropdown.
i have a custom table called u_u_hierarchy inside two columns
column 1: top_level_folder type string value "A", "B"

column 2: second_level_folder type string value "1", "2"

 

in the catalogue item:

i created a variable set inside two values
variable1 "Main": lookup select box 

michaelantoun_0-1717145731746.png

 

Variable 2 child:

michaelantoun_1-1717145825645.png

I also added a Catalog Data Lookup Definitions to match value between top_level and second_level

 

when i test it, if i choose from the top_level exe A
in the dropdown of second_level i still see 1 & 2 

i only want to see 1 and if i choose B from the top_level i want to see 2 

 

1 REPLY 1

Brad Bowman
Kilo Patron
Kilo Patron

You need a Reference qualifier and Variable attribute on the child variable.  Using a more out of the box example, recreating the incident category and sub-category dependent fields in Catalog Item variables looks like this:

BradBowman_0-1717162600922.png

BradBowman_1-1717162621744.png

BradBowman_2-1717162655463.png

BradBowman_3-1717162675505.png

The Reference qualifier limits the choices, and the Variable attribute makes sure the list is refreshed when the parent variable changes.