External Lookup Based on Queue Topic

[JohnBo15]

Has anyone had success with creating an External Lookup dropdown that provides options based off the queue topic selected on a Request? 

[Kurt_Jones]

John,

Try:

$$HOST/attask/api/v19.0/optask/search?projectID=ID of your project queue&fields=queueTopic:name

for JSON path:  $.data[*].queueTopic.name

[skyehansen]

so just to clarify, what you are asking is:

My queue topics are Fruit, Vegetable, and Color

I want my external lookup field to provide options for Apple, Orange and Banana if I select Fruit.

I want my external lookup field to provide options for Spinach, Lettuce and Broccoli if I select Vegetable.

I want my external lookup field to provide options for Blue, Red and Green if I select Color.

Am I reading that right?

[JohnBo15]

Yes. Exactly. We're looking for different options based on the queue topics. Thanks.

[skyehansen]

I would be really surprised if you can do this WHILE the issue is being created. You're basically trying to compare the issue's queue topic name to a list of your options -- while the issue hasn't been created yet. I'd be interested to see if workfront has that information stored anywhere. That said, the Workfront devs have definitely made a lot of inroads in the area of prefilling a calculation. So you could try. 

Where are you "storing" your other options (the fruits, vegetables, and colors)? I'm a simple human, so it makes sense to me to start off storing them as tasks and then seeing if I can store extra information in the task description that I can try and see if I can link back to the issue queue topic name.

[cantcacheme]

We actually tried to do this very thing in our Workfront instance and found that we could pull the Queue Topic data after the request/issue was submitted, but not while they were filling out the request. 

We ended up abandoning the idea of using Queue topics and instead came up with two options.  We could either:

• Create another external lookup, which means the users basically pick the same option twice; once when selecting the queue topic and again in the form.  Then pointing a second external lookup to the first.
• Create an individual form for each option available as a queue topic.

Although it's repetitive, we opted for the first option so we wouldn't have to make lots of form changes if we needed to change something in the future.