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

Question

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)

Tom Lister_fo1j4e · Answer

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

Tom Lister_fo1j4e · Answer

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_fo1j4e · Answer

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?