Is it possible to use global variables with JQL query

Peter Hiross

Hello,

We are using Confluence page for our release notes. The confluence page consists of a set of services where each service has a JIRA-issue filters that executes a query to capture changes made to the service over the course of several sprints.

Our query looks like this:

project = "myProject" AND fixVersion ~ "19.0.0*" AND component=myservice ORDER BY fixVersion

While this work great we have a large number of services and it requires us to edit each of these JIRA-issue filters and update the version i.e., fixVersion ~ "19.0.0* -> FixVersion ~ "20.0.0*"  for our next release.

Is there away one can set a global variable once for fixVersion   and reference this variable in our JIRA-issue Filter? 

project = "myProject" AND fixVersion ~ $FIX-VERSION AND component=myservice ORDER BY fixVersion

 

We do have scriptrunner as an option.

Thank you in advance

Bill Sheboy

Hi @Peter Hiross 

I do not believe using variables that way is possible with JQL, and...

 

Have you considered using chained filters on the page?  For example:

create one saved filter with your Fix Version test:

project = myProject
 AND fixVersion ~ "19.0.0*

Get the identifier for the filter; let's assume it is 12345.  And so a search of it would be:

filter=12345

Add that to any other searches filters needed:

filter=12345
 AND component = myservice
 ORDER BY fixVersion ASC

When your "variable" needs to change, only that first saved filter will need to change.

 

Kind regards,
Bill