Is there a way to query JIRA to get all versions that are due to be released on a certain date?

[Anthony Galati]

I am doing research for our Release team. Is there a way to see all versions that are due to be released on a particular date? This is across multiple projects.

So if I have PROJECTA, PROJECTB, and PROJECTC

PROJECTA has version 1.3 that is to be released on 12/01/11

PROJECTA has version 1.3 that is to be released on 11/11/11

PROEJCTC has version 5.0 that is to be released on 12/01/11

I want to run a query that gives me all projects, with the version, that is due to be released on 12/01/11

[Jobin Kuruvilla [Adaptavist] · Accepted solution]

JQL Tricks Plugin has a method (releasedOn(date)) that helps you to get this list : https://studio.plugins.atlassian.com/wiki/display/JQLT/Versions+Functions

[Anthony Galati]

I appreciate it, I was looking to do it just from JQL or searching.

[Jobin Kuruvilla [Adaptavist]]

It is JQL, btw :) Looks like you already nailed it with something else.

[Ian D]

Hi, i faced this too and found the way necessarry to include the date in the fixVersion (release) name in Jira, e.g, based on the example you provide:

"PROJECTA 1.3 (12/01/11)"

"PROJECTA 1.3 (11/11/11)"

"PROJECTC 5.0 (12/01/11)"

This way you see everything you need to know at a glance and no ambiguities :)

This is probably only relevant for large enterprise/multi-project instances of jira. It also helps reduce risk of jira-users accidentally assigning issues to an incorrect version (e.g. that "1.3" version in your example), and more easily spotting wrong release assignments if it does happen.

[Deepak Bhatia]

Try using advanced searching using JQL...

[Anthony Galati]

I haven tried but haven't found a viable solution