CODEWITHSUNDEEP
jira
sweetfa
sweetfa

Reputation: 5853

Query all issues with a fixVersion = next non-released version in Jira

I would like to create a query that returns issues based on a version type field that is equivalent to the next unreleased version on a particular number branch sequence.

For example:

fixVersion IN ('1.7.1')

would give me all of the issues where the fixVersion is set as 1.7.1

What I would like to do is be able to create a query that selects the next unreleased version in the 1.7 branch

For example:

fixVersion IN (NextUnreleasedVersion)

In addition I would like to get a version that is the last released version in a similar manner.

Is it possible to do this with the standard Jira query mechanism.

Upvotes: 1

Views: 6784

Answers (3)

OblongZebra
OblongZebra

Reputation: 486

You could use:

fixVersion in earliestUnreleasedVersionByReleaseDate([projectkey])

See Jira documentation

Upvotes: 3

Jeff Parsons
Jeff Parsons

Reputation: 129

If you're using sprints (greenhopper), I found there's an openSprints() function that helps you get what you want:

assignee = currentUser() AND resolution = Unresolved AND sprint in openSprints() 
   ORDER BY updatedDate DESC

Doesn't help with the fixVersion unfortunately. In that case, we've usually had a couple backlog versions to just exclude, and I've usually used something like this:

assignee = currentUser() AND resolution = Unresolved AND 
  fixVersion not in ("Feature Backlog", "Bug Backlog") ORDER BY updatedDate DESC

Upvotes: 0

mdoar
mdoar

Reputation: 6891

Not possible with standard JQL. You could try a custom JQL function with Script Runner

Upvotes: 0

Related Questions