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

Jacques Dussault February 20, 2024

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!

2 answers

1 accepted

0 votes
Answer accepted
Bill Sheboy
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.
February 20, 2024

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 February 21, 2024

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

Thank you for your help!

Like Bill Sheboy likes this
0 votes
Clark Everson
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 20, 2024

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 February 20, 2024

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)

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events