Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

JQL to fetch if an issue was completed/closed between the Version, start & Release date?


I have a structure of multiple Versions with different start and end dates, I want to find if the issue that was committed to a Version get completed between the start and end date of the version or not.


eg. Version 1 ; Start date: 5 Dec 2018 / Release date: 18 Dec 2018

Issue completion date: 15 Dec 2018 (GREEN) and 20 Dec 2018 (RED)

1 answer

Hi Kartik

I don't see a way to dynamically get release date by JQL out of box, perhaps some plugins support. However, JQL does allow you to look for issues closed within a specific period, for example

project = yourProjectName and fixVersion = yourVersion and resolved <= "2018/12/18"

Tom Lister Community Leader Oct 19, 2018

I've been looking at writing  function for a  similar issue.

How would you expect to see the data if an issue affected/fixed, multiple versions.

For us, we currently have a 1:1 relationship between issues and versions.

Tom Lister Community Leader Oct 20, 2018

Ok. But JIRA allows multiple versions and not all may have dates set. So any function would have to account for that. Maybe something like minStart or maxRelease dates.

Does it matter if it was fixed before startDate?

Do you have scriptrunner installed?

Tom Lister Community Leader Oct 20, 2018

OK. But JIRA allows multiple versions tobecset and dates may not be set so any function will need to account for that. How about minStartDate or maxReleaseDate?

does it matter if the fix is before start date? Could it just check after release date?

Do you have scriptrunner?

also this might be relevant

Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you