fixversion = all releases within a date range or quarter

[Luke Hale]

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!

[Muhammad Ramzan]

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]

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

[Crystelle S]

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]

@Luke ;)