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?
If you have script runner, you could start here
There are some examples on how to dynamically retrieving external values and displaying them as dropdown values in a text field.
When to use CSV importer When managing your processes in Jira, there are many occasions where you need to create a lot of tasks. Creating them one by one will cost you a lot of time and effort and i...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event