we use Jira to manage tickets for an application. Our jira tickets often require us to save SQL script that are related to the ticket, so we have created a custom field that we enter the SQL into. Our standard code base has components that are shared between various clients and we would like a way to select (possibly from a checkbox selection) which clients will required this SQL to be run.
Example, we have 10 clients and Jira ticket 123 is for a feature that requires us to run SQL at time of deployment for client 1, client 5, and client 7 only. Is there a way to specify the SQL we enter into our custom SQL field is only for those three clients.
Likewise, the next ticket may have SQL that will need to be collected for only client 1.
Basically at the end of the release, i would like a way that i could gather all the SQL from all the tickets for that release by client. So I would like to either query Jira or be able to request all the SQL related to client 1 or client 5 for a specific release.
How can this be accomplished?