External Lookup Based on Queue Topic | Community
Skip to main content
Adobe Employee
January 31, 2025
Solved

External Lookup Based on Queue Topic

  • January 31, 2025
  • 2 replies
  • 662 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by 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.

2 replies

Kurt_Jones
Community Advisor
Community Advisor
January 31, 2025

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
Community Advisor and Adobe Champion
January 31, 2025

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?

JohnBo15Adobe EmployeeAuthor
Adobe Employee
January 31, 2025

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

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe ChampionAccepted solution
January 31, 2025

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.