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

[Kartik Gupta]

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)

[Daniel Deng]

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]

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.

[Kartik Gupta]

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

[Tom Lister]

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]

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

https://community.atlassian.com/t5/Jira-questions/Populate-custom-date-field-with-release-date-of-the-version/qaq-p/871885

[Tom Lister]

This may also help

https://community.atlassian.com/t5/Jira-questions/Set-Issue-Due-Date-based-on-fixVersion-release-Date-with-Script/qaq-p/678889