Hello, I realize this question has been posted for a while, but I found a new way to do this that's a bit hacky and at least doesn't require any additional tables to be created or a lot of code to be written. I haven't thought too long and hard about whether there are any major downsides to doing this either, so be careful I suppose.
The process is:
- Create the parent variable as a "Select Box" field and enter all of your values.
- Create the child variable first as a "Select Box" and create all the child values, making sure that the "value" for each option starts with the parent value you want it dependent on.
- Once you have all the values entered, change the type of the child variable to "Reference" and enter the following in the Type Specifications:
- Reference: "Question Choice [question_choice]"
- Use reference qualifier: Advanced
- Reference qual: javascript:"question=<sys_id of current variable record>^valueSTARTSWITH" + current.variables.<name of parent variable>
For example:
You'll need to remember (maybe add some documentation?) to change it back to a select box if you need to add any other options, or tweak the logic for when to show the choices related list so it shows in this new situation.
You don't get a normal dropdown in the service catalog view, but it works, and it's very nice in the Service Portal.
