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

External Lookup Based on Queue Topic

  • January 31, 2025
  • 2 replies
  • 655 views

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

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

skyehansen
skyehansen
New Participant
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?

    J
    JohnBo15Author
    Employee
    January 31, 2025

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

      skyehansen
      skyehansenAccepted solution
      New Participant
      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.

        Kurt_Jones
        Kurt_Jones
        New Participant
        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

         

          Terms & ConditionsAccessibility statement

          Loading footer...