Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

fixversion = all releases within a date range or quarter

Luke Hale
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 11, 2019

Hi,

I'm on a project with multiple releases per quarter, and occasionally unknown patch releases which are created as and when they're needed. I'm looking to create a filter to use as a roadmap which can show me all Epics with a fix version within a current (or next) quarter. Jira seems to have a concept of endOfDay(), endOfWeek(), and endOfMonth(), but nothing related to quarters. Is there some way around this?

I'm currently using a search which is similar to:

issueType = Epic AND fixVersion = earliestUnreleasedVersion(Project)

But this picks up only the earliest planned unreleased version, but there are a few which have release dates between now and the end of the quarter (patches for the previous release, etc). Is there any way to do this or any plans for an endOfQuarter() operator? (I would use this as a workaround using the duedate query instead of checking version).

Cheers!

2 answers

0 votes
Crystelle S
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 13, 2021

I built a Kanban swimlane for items in the current quarter and then future quarters (we have scriptrunner) but I did figure out this in case it helps someone:

fixversion in releaseDate('after startOfYear()') AND fixversion in releaseDate('before startOfYear(90d)')

fixversion in releaseDate('after startOfYear(90d)') AND fixversion in releaseDate('before startOfYear(181d)')

fixversion in releaseDate('after startOfYear(181d)') AND fixversion in releaseDate('before startOfYear(273d)')

fixversion in releaseDate('after startOfYear(273d)') AND fixversion in releaseDate('before endOfYear()')

Crystelle S
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 13, 2021

@Luke ;)

Like George Pomar likes this
0 votes
Muhammad Ramzan(Atlassian Certified Master)
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 23, 2019

There is no straightforward way to do that, this  plugin can help you to find the required results

 

Following queries are very useful for scrum masters to get the releases as per their requirements.

This will get the releases versions in a specific date range

fixVersionReleasedBetweenDates("2018-05-26", "2018-07-01")

This will get the affected versions in a specific date range

 affectedVersionReleasedBetweenDates("2018-05-26", "2018-07-01")

 

will get all fix versions released before a specific date

fixVersionReleasedBeforeDate("2018-05-26") 

will get all affected versions released before a specific date

affectedVersionReleasedBeforeDate("2018-05-26")

 

will return fixed or affected releases on a specific date

fixVersionReleasedOnDate("2018-05-26") OR affectedVersionReleasedOnDate("2018-05-26")

 

 

There are a lot of other queries available with this plugin

https://jqlsearchextensions.atlassian.net/wiki/spaces/SEARCH/pages/30497099/JQL+Reference+Server#JQLReference(Server)-FixVersionReleasedBetweenDates

Luke Hale
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 24, 2019

Thanks for the answer! I'll give that plugin a whirl!

Suggest an answer

Log in or Sign up to answer