create a cascading dropdown in catalogue item
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-31-2024 02:02 AM
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
Variable 2 child:
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-31-2024 06:38 AM
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:
The Reference qualifier limits the choices, and the Variable attribute makes sure the list is refreshed when the parent variable changes.