In a JQL, is it possible to query for all issues in Releases released in the last 6 months.

[Jacques Dussault]

The keyword here is releases. It is easy to have issues resolved or updated in the last 6 months, but what we are looking for is the content of every release released in the last 6 months, and only the issue in theses releases.

Thank you!

[Bill Sheboy · Accepted solution]

Hi @Jacques Dussault 

That is not possible with the out-of-the-box features of JQL.  It only has some functions to help with relative comparisons, such as checking versions are in the earliest unreleased version, and so on: https://support.atlassian.com/jira-software-cloud/docs/jql-functions/#earliestUnreleasedVersion--

To query the release attributes you could investigate Atlassian Marketplace apps which add to the features of JQL.  That may make sense if you need this type of query often, so please check if you already have such addons.

If you need this infrequently, and for just one project, you could manually (or with the REST API functions) identify the releases in the project for the timeframe, and then manually construct a query to check for issues in the releases.

Kind regards,
Bill

[Jacques Dussault]

You're confirming what I was expecting. I guess we'll stick to the manual update of the query. 

Thank you for your help!

[Clark Everson]

Hi @Jacques Dussault 

This should work: resolutiondate >= startOfMonth(-5) AND resolutiondate <= endOfMonth(-1) AND fixVersion IN releasedVersions()

However I would scope it to specific projects

Best,

Clark

[Jacques Dussault]

It a good way to get rougly there but it still  leaves some releases without all their issue as some have been resovled before that period.

That is why I was hoping to be able to give a range of dates on the release date of the actual release, not the issues, and query all the issues inside these releases.

Right now, to get the results I wish, I list the releases manualy in the JQL by naming them one by one in release with  fixVersion in () but that will require regular update in the future to add and remove some to keep looking at the last 6 months.

I am wondrering if thre is some kind of formula close to  fixVersion(releasedate<=180d)