External Lookup Based on Queue Topic | Community
Skip to main content
JohnBo15
Employee
Jan 31, 2025 2:43 PM UTC
Solved

External Lookup Based on Queue Topic

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

skyehansen
skyehansenAccepted solution
Level 4
Jan 31, 2025 7:15 PM UTC

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.

View reply

5 replies

skyehansen
skyehansen
Level 4
Jan 31, 2025 6:10 PM UTC

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?

Translate
    JohnBo15Author
    Employee
    Jan 31, 2025 6:22 PM UTC

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

    Translate
      skyehansen
      skyehansenAccepted solution
      Level 4
      Jan 31, 2025 7:15 PM UTC

      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.

      Translate
        Kurt_Jones
        Kurt_Jones
        New Participant
        Jan 31, 2025 4:02 PM UTC

        John,

        Try:

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

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

         

        Translate
          Terms & ConditionsAccessibility statement

          Loading footer...