JIRA drop down menu of dynamically populated clickable links

[Charles Licata]

We are using JIRA and have a need to show deployment of SQL code separately as an extra step when it is part of a ticket and ready for Production release.  Currently, we create a separate sub-ticket for deploying SQL with a check that the parent ticket cannot be advanced in the workflow unless the sub-ticket is closed. 

As an alternative to this process of creating two tickets, I was thinking that a new "SQL Component Included" drop down menu custom field would be added to a ticket with "No" as the default choice and the balance would be dynamically populated as clickable links from the file names in a specified SVN directory.  Should any other value other than "no" be chosen, then a message would be displayed when advancing the workflow when exiting deployment to confirm the SQL has been deployed.  The deployment specialist would use this clickable link for access to the SQL needed. 

I've searched this board and cannot find something similar.  Is there a plug-in currently available that would accomplish this?

[Gezim Shehu [Communardo]]

If you have script runner, you could start here

https://scriptrunner.adaptavist.com/latest/jira/behaviours-conversions.html

There are some examples on how to dynamically retrieving external values and displaying them as dropdown values in a text field.